ntrain - See my post "Default Values" the spreadsheet there has dro
down boxes on it. Download the spreadsheet and you will be able to se
what I did. Basically for each box I created a lsit onthe second sheet
Then When I right Click on the box I got to format control, from ther
I can control the cells to be browsed for the values.
If this doesn't suityour needs, please post back with an
explanation of what it is you need to accomplish. The other
two types of dropdowns come from the "Forms Toolbar" and
the "Control Toolbox" and all function slightly differently.
I tried the aforementioned method, but it did not work for me. I got a
far as creating the list that I was trying to put in the drop down men
and I selected the cell that I wanted the menu to be located in, but
cannot find an option that will allow me to create this. May I hav
more help please
From the menu's choose
Data -> Validation and a form will pop-up
under the "Settings" tab in the "Allow" field choose "List"
in the "Source" field enter your list (ie. =$A$1:$A$10)
Your list must be on the same page, unless you use a
named range.
I am confused as to what step you are on. Did you create the Box itsel
(even if it is empty). If so, and you have created your list o
choices. You should be able to right click on the Box and go into th
Format Control menu. Are you this far? E-mail me if you get a chanc
I'll be working from 7:00 a.m. to 3:30 p.m on Wednesday and should se
the e-mail before i see the follow up post. (e-mail address removed)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
