Loading Combobox from excel range

MickeyGreen
02-17-2006, 11:27 AM
I have a combobox in a userform and I want to populate it with what is contained in an excel range. Is there a way to do this using the AddItem method? Or is there a better way to permanantly link the combobox to the range?

Any help would be awesome!

Thanks.

MickeyGreen
02-17-2006, 11:31 AM
RowSource! Eureka!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum