userforms
If the other workbook is open, then you can display a userform from the
other workbook using "Application.Run..." to call the sub in the other
workbook that shows the form...
Sub ShowTheOtherForm()
Application.Run "OtherBook.xls!OtherRoutine"
End Sub
"Zaahir"
wrote in message
hi
can i open a userform located on a different workbook?
Regards
|