ExcelBanter - Issue with ComboBox on a UserForm

That's it!!
I am humbled.

Regards,
Ryan---

--
RyGuy

"Jim Cone" wrote:

RyGuy,
Looks like what I posted only works if the source range workbook is an external workbook..

Vba code like this works for me...

UserForm1.ComboBox1.RowSource =
ThisWorkbook.Worksheets("Welcome").Range("AG42:AG9 2").Address(External:=True)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"ryguy7272"
wrote in message
Thanks for the look Jim, but still no-go here. It looks reasonable, but when
I tried it I got €˜Could not set RowSource property. Invalid Property
Value.. Any more ideas out there?
Regards,
Ryan--
--
RyGuy

"Jim Cone" wrote:
Ryan-
Try...

[NameOfWorkbook]WELCOME!AG42:AG92
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)