| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to create a form that will stop you if you leave a cell bla
If you leave a cell blank with a particular row, I want to not let the person
move forward by either locking or hiding the following cell. For example if A1 is blank then B1 is no accessable, if B1 is left blank then C1 is not accessible. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trying to create a form that will stop you if you leave a cell bla
You can do it with custom data validation.
Data - Validation... - Custom - =A1<"" Ensure that you uncheck Ignore Blanks -- HTH... Jim Thomlinson "CarTel Boy" wrote: If you leave a cell blank with a particular row, I want to not let the person move forward by either locking or hiding the following cell. For example if A1 is blank then B1 is no accessable, if B1 is left blank then C1 is not accessible. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a form and find a value in one cell and replace a value in | Excel Worksheet Functions | |||
| How to leave form displayed | Excel Programming | |||
| How to leave form displayed | Excel Programming | |||
| Modal form won't leave | Excel Programming | |||
| Show user form, leave wosksheet active | Excel Programming | |||
![CarTel Boy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
