Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
I am trying to use a CommandButton called "NEXT" to trigger an event. If there was any data entered into any one of 50 cells (a named range called "CustInfo"), I need a CommandButton called "Save Info" to become visible and the "NEXT" button to become invisible. If there is no data entered into "CustInfo", Then I only need the "NEXT" button to become invisible (the "Save Info" button is already invisible). I know how to turn the CommandButtons on and off. I just don't know how to detect if anything was entered into any of the cells in the "CustInfo" named range. Anyone have any ideas? Any help would be appreciated. TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Limit data entry in range of cells | Excel Worksheet Functions | |||
Detect strings in a range | Excel Worksheet Functions | |||
Detect non-blank range | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Data Entry in a cell still in progress - how to detect and correct | Excel Programming |