Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
load user forms
Well I thought I had this last part all figured out-- my other forms load
this way with no trouble whatsoever, but not this latest one.... argh!!! As far as I can tell, in order to call a form from the xlam-- once the xml code is in place-- is to create another macro, in a module, within the xlam file. sub userform1(control as IRibbonControl) userform.show end sub this has worked on 5 other user forms that I have, but not this one. I've quadruple checked and the modules, and forms are in place. Thankfully, nothing has disappeared here-- that I can tell. Would someone please explain to me how to get a user form to start up? Thank you. Best. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
load user forms
Ok, this one is resolved.
I don't know why, but typing the names did not work, so I copied them, and now it works. Which is weird, because I'd copied and pasted them a few times. Go figure..... grrrrr..... "Steve" wrote: Well I thought I had this last part all figured out-- my other forms load this way with no trouble whatsoever, but not this latest one.... argh!!! As far as I can tell, in order to call a form from the xlam-- once the xml code is in place-- is to create another macro, in a module, within the xlam file. sub userform1(control as IRibbonControl) userform.show end sub this has worked on 5 other user forms that I have, but not this one. I've quadruple checked and the modules, and forms are in place. Thankfully, nothing has disappeared here-- that I can tell. Would someone please explain to me how to get a user form to start up? Thank you. Best. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form - how to load it | Excel Discussion (Misc queries) | |||
Load user form?? | Excel Programming | |||
Load forms from another workbook | Excel Programming | |||
can i have VBA & forms etc load then unload? | Excel Programming | |||
Excel :: Creating Entry Forms that auto load a workbook | Excel Programming |