Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create a questionaire with drop down menus to choose different
answers. I have the drop down menu but I am not sure how to enter the text in it that I want to give as answer options? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am assuming that you have added droop down combo boxes from either the
forms toolbar or from the control toolbox. The control works a little differently depending where you got it from. If it came from the form toolbar then when you right click on it you will see "Assign Macro" in the list. Otherwise it is from the control toolbox and Properties will be in the list. Let us know which kind you have... -- HTH... Jim Thomlinson "Kerri" wrote: I am trying to create a questionaire with drop down menus to choose different answers. I have the drop down menu but I am not sure how to enter the text in it that I want to give as answer options? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have managed to get some options in the drop down menu - my struggle now is
having the option (for example it says Choose one) stay there when you click away from the cell. Right now it just goes blank so you wouldn't even know there is the option of a drop down menu. "Jim Thomlinson" wrote: I am assuming that you have added droop down combo boxes from either the forms toolbar or from the control toolbox. The control works a little differently depending where you got it from. If it came from the form toolbar then when you right click on it you will see "Assign Macro" in the list. Otherwise it is from the control toolbox and Properties will be in the list. Let us know which kind you have... -- HTH... Jim Thomlinson "Kerri" wrote: I am trying to create a questionaire with drop down menus to choose different answers. I have the drop down menu but I am not sure how to enter the text in it that I want to give as answer options? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop down boxes | Excel Discussion (Misc queries) | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop Down Boxes | Excel Worksheet Functions | |||
Drop-down boxes | Excel Discussion (Misc queries) |