Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
load userform from other VBProject (Excel 2000)
"Fero Bokor" wrote in message ... Hi all, is it possible to load (to show) a UserForm from other VBAProject ? There is a Reference between ActiveVBProject and the other VBAProject . Thanks a lot ... Fero Not directly but you can call a procedure in code module in that other workbook which shows the form Example In Project A you have a form called MyForm Create a code Module called MyCode and add the procedure Public Sub ShowMyform MyForm.Show End Sub In Project B after you have set a reference you can say A.ShowMyform Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
load userform from other VBProject (Excel 2000)
It works ...
Thanks, Keith Fero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all of a sudden my excel 2000 won't load | Excel Discussion (Misc queries) | |||
How to load a listbox in a userform? | Excel Discussion (Misc queries) | |||
Load caption box on userform open | Excel Worksheet Functions | |||
Load image from directory for custom toolbar of Excel 2000 | Excel Worksheet Functions | |||
why templates do not load into excel 2000? | Excel Discussion (Misc queries) |