Coding an Array

2077delta · Feb 18th, 2002, 12:57 PM

I would like to be able to have a combo box with a defined set of values available at all times. How do I code a multi-dimension array and make it available to the combo box? Once the user selects the item from the list it is copied to the active cell in the work sheet. I plan to put the form with the combo box in my personal macro file.

Juan Pablo González · Feb 18th, 2002, 01:54 PM

If you are going to use a UserForm with a ComboBox, then I'd suggest using the _Initialize() event of the UserForm to load the values of the ComboBox.

Feb 18th, 2002, 01:54 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If you are going to use a UserForm with a ComboBox, then I'd suggest using the _Initialize() event of the UserForm to load the values of the ComboBox. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Feb 18th, 2002, 12:57 PM	#1
2077delta Board Regular Join Date: Feb 2002 Posts: 217	I would like to be able to have a combo box with a defined set of values available at all times. How do I code a multi-dimension array and make it available to the combo box? Once the user selects the item from the list it is copied to the active cell in the work sheet. I plan to put the form with the combo box in my personal macro file.