View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Forum freak \(at work\) Forum freak \(at work\) is offline
external usenet poster
 
Posts: 12
Default 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