ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop Down Boxes (https://www.excelbanter.com/excel-discussion-misc-queries/179963-drop-down-boxes.html)

kerri

Drop Down Boxes
 
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?

Jim Thomlinson

Drop Down Boxes
 
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?


kerri

Drop Down Boxes
 
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?



All times are GMT +1. The time now is 12:50 PM.

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