MrExcel.com - Your One Stop for Excel Tips & Solutions

Drop Down Box in Data Form

Posted by Richard S on May 10, 2001 10:51 PM

I have absolutely no knowledge of programming, and don't really want to get into VBA at this stage, however I am using a data form in an Excel database, and would like to have a drop down box in one of the fields. Anyone any ideas?

Posted by JooBoe on May 10, 2001 11:04 PM

Use the 'Data Validation ' function..

Posted by Dave Hawley on May 11, 2001 12:54 AM

Hi Richard

As has been suggested, the Validation feature under Data on the main toolbar will do this. I have some examples of this feature on my Website under "Handy Hints".

Dave

OzGrid Business Applications

Posted by Richard S on May 13, 2001 4:31 PM

Dave

I am using data validation on the sheet, but I also have formulae attached to some of the other data. Rather than have the user have to copy the formulae down, I want to use a data form so Excel does this itself. What I want is for the drop down list from my data validation to appear in the data from.

Richard