LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
 
Posts: n/a
Default

hi,
that is a combo box. it's in the toolbox.
toolscustomizetoolbar tabcontrol toolbox
put all of your option that will be in the combo box in a
vertical 1 column range off out of the way. say IS1:IS10
right click the combo box. click properties.
Set the ListFillRange to your options in this example it
would be IS1:IS10
Set the ListRows to 10(for this example. i don't know how
may options you are going to have.)
click exit design on the control tool box and you are done.


-----Original Message-----
I want to make pulldown text boxes in excel as I do in

access

Can it be done?
.

 
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
how to select multiple text boxes in excel for formatting Rob New Users to Excel 3 April 2nd 23 08:38 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Text Boxes Graham Parkinson Excel Discussion (Misc queries) 2 December 2nd 04 05:01 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM
How to Make the text blink in Excel? rajesh aiyappa Excel Worksheet Functions 3 October 29th 04 09:24 PM


All times are GMT +1. The time now is 12:21 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"