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.
Voxx International. Voxx International is an American consumer electronics company founded as Audiovox Corporation in 1965 and renamed Voxx in 2012. It is headquartered in Hauppauge, New York. The company specializes in four areas: OEM and after-market automotive electronics, consumer electronics accessories, and consumer and commercial audio equipment.