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. |
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. |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com