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