Thank you very much, it would have been nice if it were mentioned ANYWHERE in the help for the CALL command that you can't pass it the name of a procedure as a string variable. Oh well, live and learn. The frustrating part is that it is such a simple fix, yet I probably spent 4 hours trying to...
I highly recommend John Walkenbach's Excel 2002 Power Programming for VBA, I had never really programmed much of anything, I bought it, it's easily worth the $50, read it basically cover to cover, and now i'm getting pretty good with it. It also helps to learn it if you have something in mind...
I'll try to explain this as simply as possible.
I am creating an add-in with a bunch of toolbars. I want the common subs such as AddToolbartoMenu() and DeleteToolbar() to be contained in one module for the obvious simplicity in making changes. But I want the individual toolbars to each have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.