Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using MSOffice2003
From reading around the groups and following helpful links I learned how to create a list on sheet1 and name the range and use the offset command to set up data validation as a means for filling drop boxes on my main worksheet. Problem is, I don't know how to get the actual drop box into the cells in the necessary column on my worksheet. Duh, it can't be that hard but I have no clue how to proceed. All help gratefully accepted by this newbie. Thanks Joanne |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
if you are using data validation... see this site. It explains how to do that. http://www.contextures.com/xlDataVal01.html#DataVal01 real good site too. lot of good tip concerning a great number of thing. after reading up on validation. click home then tips. Regards FSt1 "Joanne" wrote: Using MSOffice2003 From reading around the groups and following helpful links I learned how to create a list on sheet1 and name the range and use the offset command to set up data validation as a means for filling drop boxes on my main worksheet. Problem is, I don't know how to get the actual drop box into the cells in the necessary column on my worksheet. Duh, it can't be that hard but I have no clue how to proceed. All help gratefully accepted by this newbie. Thanks Joanne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |