Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox Issue Duncs Excel Programming 0 July 26th 06 04:16 PM
Combobox issue! EagleWolf Excel Programming 2 November 12th 05 01:22 PM
Combobox Issue Andy Excel Programming 2 July 27th 05 04:27 PM
Another ComboBox Issue Darrin Henry[_2_] Excel Programming 2 April 16th 05 03:03 PM
Another ComboBox Issue Darrin Henry[_2_] Excel Programming 1 April 16th 05 09:18 AM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"