activex combo box on excel sheet

davers5 · Apr 2nd, 2002, 05:21 PM

If I view the forms toolbar and pick a combobox and put it on a worksheet, how do I find it's name? Also, does it show up somewhere in the VB Editor environment? Can I set properties for it?

Dave

Duane · Apr 2nd, 2002, 06:05 PM

I'm not sure what you want to know.

If you put a combobox in your spreadsheet, rick-click on it and you'll see "Format Control" on the pop-up menu.

Select it, and head to the Control tab, where you'll see the various controls for this box. For example, you may want someone to choose from one of 50 states; write the 50 states down a column, and then when you set up your combobox, you'll set the input range to pick up the range that contains the states; now, when someone clicks on the combobox, they can select one of the states when it pulls down.

There are other fun things you can do with comboboxes, but let me know if this is in the direction of info you needed to begin with.

Dave Hawley · Apr 2nd, 2002, 09:39 PM

Hi Dave

If the ComboBox is from the Forms toolbar it's not an ActiveX control (Control toolbar is). To see the name though, just select it and look in the "Name Box" (left of formula bar). You can also rename it here,

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-04-02 20:40 ]

davers5 · Apr 3rd, 2002, 12:21 PM

Thanks guys, I'm beginning to understand this better. But I don't understand what the difference is between the controls on the forms toolbar and the ones on the controls toolbar. How are these different from what you'd put on a userform? Do they still support the same properties and methods as a combobox on a userform?

Dave

Apr 2nd, 2002, 06:05 PM	#2
Duane Board Regular Join Date: Mar 2002 Location: Toronto Posts: 173	I'm not sure what you want to know. If you put a combobox in your spreadsheet, rick-click on it and you'll see "Format Control" on the pop-up menu. Select it, and head to the Control tab, where you'll see the various controls for this box. For example, you may want someone to choose from one of 50 states; write the 50 states down a column, and then when you set up your combobox, you'll set the input range to pick up the range that contains the states; now, when someone clicks on the combobox, they can select one of the states when it pulls down. There are other fun things you can do with comboboxes, but let me know if this is in the direction of info you needed to begin with. __________________ Regards, Duane h. Office2003 in WinXP o. Office2007 in Win7

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 05:21 PM	#1
davers5 Board Regular Join Date: Feb 2002 Posts: 255	If I view the forms toolbar and pick a combobox and put it on a worksheet, how do I find it's name? Also, does it show up somewhere in the VB Editor environment? Can I set properties for it? Dave

Apr 2nd, 2002, 09:39 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Dave If the ComboBox is from the Forms toolbar it's not an ActiveX control (Control toolbar is). To see the name though, just select it and look in the "Name Box" (left of formula bar). You can also rename it here, _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-04-02 20:40 ]

Apr 3rd, 2002, 12:21 PM	#4
davers5 Board Regular Join Date: Feb 2002 Posts: 255	Thanks guys, I'm beginning to understand this better. But I don't understand what the difference is between the controls on the forms toolbar and the ones on the controls toolbar. How are these different from what you'd put on a userform? Do they still support the same properties and methods as a combobox on a userform? Dave