userform.show question?
 

"Userform1.show" calls userform1 from the workbook but how do i call up
userform1 from a diff workbook that is already open.

Thanks
Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=566636

userform.show question?
 

that isn't really supported. Certainly not directly.

You would need to call a routine in the other workbook that shows the
userform and returns an reference to it.

--
Regards,
Tom Ogilvy



"T.c.Goosen1977" wrote:


"Userform1.show" calls userform1 from the workbook but how do i call up
userform1 from a diff workbook that is already open.

Thanks
Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=566636