#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down boxes april Excel Discussion (Misc queries) 2 April 19th 07 10:11 PM
Drop down boxes Reen Excel Discussion (Misc queries) 2 July 20th 06 02:50 PM
drop down boxes stumakker Excel Discussion (Misc queries) 3 January 16th 06 01:42 PM
Drop Down Boxes tiab86 Excel Worksheet Functions 2 July 30th 05 05:32 PM
Drop-down boxes rich76 Excel Discussion (Misc queries) 1 January 4th 05 05:09 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"