Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I get code to run all the time? That is, not when an event occurs. I
have the following code that I'd like to use ... Sub Volume() If Sheets("Input").Range("Total_Vol").Value < 500 Then PT_Yes.Enabled = False PT_No.Enabled = False PT_No.Value = True End Sub Is it possible (a) to run the code - i.e. will the syntax work and (b) to run the code as a constant check and not as an event? PT_Yes and PT_No are ActiveX OptionButtons. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
How to assign same code inside Option button code space ?? | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |