Re: Excel VBA-Worksheet_Change Function. Hi, thanks for the amended code. I meant to put the worksheet_change code into the active worksheet, not the 'this workbook'. When i change the cell value in C5:C31 to 'sent', the code works perfectly, and that's what i wanted.ere is my code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range(D5 31)) Is Nothing Then Select Case Target.Cells.Value Case Sent OrderSentTime_userform.Show End Select Else Unload OrderSentTime_userform Exit Sub End If End Sub The code works perfectly on its own.
VX (IUPAC name O-ethyl S -[2-(diisopropylamino)ethyl] methylphosphonothioate) is an extremely toxic substance that has no known uses except in chemical warfare as a nerve agent. It is a tasteless and odorless liquid.
Maxx is a part of the TJX Companies Inc., a $31B global off-price retailer with eight (8) retail brands in nine (9) countries.... Easily apply 12 days ago - save job - more...