RefEdit on Userform to pick up range in another workbook
 

Not possible to use a RefEdit control on a modeless userform, and
"application.inputbox type:=8" is modal.

..........so how do I make a userform (within an add-in) that is going
to accept ranges from two different workbooks: it's got to be user
friendly! - that's why i was hoping to use the refEdit control

(the built-in RefEdit controls in Excel can go between workbooks no
problem - or are they different controls?)

Any help greatly appreciated

Jason

RefEdit on Userform to pick up range in another workbook
 

Use
set rng = Application.InputBox( type:=8)

--
Regards,
Tom Ogilvy



"jase" wrote in message
ups.com...
Not possible to use a RefEdit control on a modeless userform, and
"application.inputbox type:=8" is modal.

.........so how do I make a userform (within an add-in) that is going
to accept ranges from two different workbooks: it's got to be user
friendly! - that's why i was hoping to use the refEdit control

(the built-in RefEdit controls in Excel can go between workbooks no
problem - or are they different controls?)

Any help greatly appreciated

Jason