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.
The V-series is the second family of nerve agents and contains five well known members: VE, VG, VM, VR, and VX, along with several more obscure analogues such as VP. The most studied agent in this family, VX, was invented in the 1950s at Porton Down in the United Kingdom.