| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Restrict cell entry until another cell has random text
data validation for the cell B1 | go to data | validation | custom | Allow: custom | formula : =A1<"" | uncheck ignore blank | ok On Oct 24, 7:39*pm, "Forum freak \(at work\)" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Restrict cell entry until another cell has random text
Kenny,
Use data validation on B1 with the custom formula =A1<"" HTH, Bernie MS Excel MVP "Forum freak (at work)" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Restrict cell entry until another cell has random text
Ah, the uncheck ignore blank was confusing me - got it working now
Many thanks to all for assisting. Kenny W "muddan madhu" wrote in message ... data validation for the cell B1 | go to data | validation | custom | Allow: custom | formula : =A1<"" | uncheck ignore blank | ok On Oct 24, 7:39 pm, "Forum freak \(at work\)" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
