Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check cell for data before running code
I want to ensure G9 on a worksheet contains a value before the main body of
code is run. If G9 contains a value do not remind the user, if G9 does not contain a value remind the user to enter a value in G9. Anyone know what I need to enter at the start of a running code? If anyone thinks I should approach this from a different angle please let me know. Thanks Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check cell for data before running code
hi,
the most simple of all but there are many others olutions than can let enter something while you're running the program. try this in the beginning of your program. if isempty(cells(9,7) then msgbox "you've got something to enter in G9 befor teh program runs" exit sub end if So long "Pat" a écrit dans le message de news: ... I want to ensure G9 on a worksheet contains a value before the main body of code is run. If G9 contains a value do not remind the user, if G9 does not contain a value remind the user to enter a value in G9. Anyone know what I need to enter at the start of a running code? If anyone thinks I should approach this from a different angle please let me know. Thanks Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have code check cell contents on edit. | Excel Worksheet Functions | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Check for instance of EXCEL running | Excel Programming | |||
check for running app | Excel Programming | |||
Check for Excel version before running? | Excel Programming |