View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jase[_2_] jase[_2_] is offline
external usenet poster
 
Posts: 29
Default 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