| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict cell entry until another cell has random text
Hi
I am sure I should be using data validation but cant seem to do the following, I want to stop the user entering data into B1 until they have entered something into A1. I thought I could get a message box to pop up when they select B1 if A1 is empty. When A1 is populated they can proceed as normal. Any help would be appreciated. Kenny W XP pro Office 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| How to Restrict Random Numbers? | Excel Discussion (Misc queries) | |||
| lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
| How can I restrict a cell(s) to alpha-only data entry? | Excel Discussion (Misc queries) | |||
| How do I restrict entry into a cell to only alpha/numeric? | Excel Worksheet Functions | |||
Threaded Mode
