Open a form in another workbook

[starl]

I have two workbooks - A & B. If workbook A is open, can I have it open only the form in Workbook B? I want workbook A on top, but the form open - don't want to see workbook B.

thanks

 

[NateO]

I would move it. But, see: link

 

[starl]

you have a point.... Workbook A is a huge wkbk. Workbook B contains searchable data. I want to call the form from wkbk A...I'd like to keep the form w/B since that's where the data is...

 

[NateO]

Export from then import from the other?

 

[starl]

everytime its used? no...
guess I'll have the form in wkbk A and just have it go to wkbk B for data....

 

[NateO]

NO is right. Just once, and then yes, then go after WB 2 from there.

NO

 

[DRJ]

Just import the userform to wb B and set up links in wb B to the data you need in wb A. Then have the userform get its data from these linked cells.