adding userform controls programmatically

T

Tim Golobic

Awhile back I found a site that had a fabulous bit of code that
created an entire userform with controls, but not dynamically. When
the code was done, you actually had a form to continue to add to or
edit, it didn't disappear in memory.

Every control was included, buttons, boxes, combos, tab strips
multipage, etc. Different colors were added. A very impressive
tutorial. It may have been part of a larger series of online guides.

Of course I should have saved that tutorial back in the spring because
I am in desperate need of it again. The problem I am having is that
not once, but twice, Excel has mysteriously corrupted a large userform
I have had. The first time several controls had disappeared, now the
entire form is blank. The goal this time is to actually have the code
create the form in case this corruption ever happens again that I can
be recreated in a matter of seconds.

If on a chance anyone is familiar with what I am looking for, please
point me in the right direction.

Thanks

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top