MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pick from Pulldown within Cell

Posted by VBDummy on January 03, 2002 9:57 AM

I apologize for asking such a remedial question, but I can't figure this out or find it in archives.

For timesheet use, how can user select from pull-down list of possible choices within single column?

Many thanks for accomidating an imbecile...

Posted by Ed on January 03, 2002 11:00 AM


Select the cell you want and then use the Data pull down. Select Validation. Select Time from the Allow Option.


Posted by Bill on January 04, 2002 3:44 AM

Thanks for the help, Ed!

What I am trying to accomplish is that on the timesheet I am doing the employee picks one job out of a list of several options... eg pull down has picks for Analysis, Authoring, Illustration... they select from the list, and that gets populated into the cell...

I will keep testing with the validation options... your help is greatly appreciated!


Posted by Bill on January 04, 2002 3:48 AM

I got it Ed!

Under validation, choose list, and select the cells that make up the list... viola pull-down I was after.

I owe you a beer!