Combobox
 

I have a userform with a combobox in it. i cant figure out the code to fill
the combobox. i have looked, but cant get anything to work.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1

Combobox
 

http://www.exceltip.com/st/Create_Us...Excel/629.html

Regards,

Alan


"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6e72d1002d858@uwe...
I have a userform with a combobox in it. i cant figure out the code to
fill
the combobox. i have looked, but cant get anything to work.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1

Combobox
 

use the rowsource property. Make an entry like

Sheet1!A1:A200

--
Regards,
Tom Ogilvy


"brownti via OfficeKB.com" wrote:

I have a userform with a combobox in it. i cant figure out the code to fill
the combobox. i have looked, but cant get anything to work.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1

Combobox
 

this shows how to insert choices within in the code. i need my choices to
come from a named range on a sheet in the workbook.



Alan wrote:
http://www.exceltip.com/st/Create_Us...Excel/629.html

Regards,

Alan

I have a userform with a combobox in it. i cant figure out the code to
fill
the combobox. i have looked, but cant get anything to work.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200702/1