ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Drop List (https://www.excelbanter.com/excel-programming/403402-drop-list.html)

Joanne

Drop List
 
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

FSt1

Drop List
 
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



All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com