Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Control ToolBox ComboBox

I am looking for the format of entering the list in the properties of a
combobox (Control ToolBox). Would I enter the range in the "ListFillRange"
Property? If so, how do I enter it to refer to a different sheet (what is the
text?)
--
Thank You,
Steve
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Control ToolBox ComboBox

You have the correct property - in the box to the right of the property type
A1:A10 and press enter.

You can also populate a combo box via code but it may be simplier to use a
spreadsheet range.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Steve D" wrote:

I am looking for the format of entering the list in the properties of a
combobox (Control ToolBox). Would I enter the range in the "ListFillRange"
Property? If so, how do I enter it to refer to a different sheet (what is the
text?)
--
Thank You,
Steve

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
Control Toolbox [email protected] Excel Discussion (Misc queries) 1 August 29th 08 05:58 PM
Where is the control toolbox? Sol New Users to Excel 3 December 1st 06 10:50 AM
Control Toolbox [email protected] Excel Discussion (Misc queries) 3 July 20th 06 03:10 PM
Control toolbox HISNA Excel Worksheet Functions 0 March 9th 06 06:14 PM
Control Toolbox John Data Excel Worksheet Functions 3 June 23rd 05 05:42 PM


All times are GMT +1. The time now is 03:21 PM.

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

About Us

"It's about Microsoft Excel"