Change location of commandbuttons on multi page in userform using vba

**newbi004** · 04-19-2013, 07:37 AM

Hi all

Can this be done?

I have a userform with a multipage control with 12 pages. Page (0) is called Frequently Used. Pages 1 to 12 all have a number of command buttons. The code for each command button has a code which identifies which page it is on. If any command button is used at least once, I want to move that command button to the Frequently Used page (Pages(0)).

Is this possible programatically?

Cheers

**Norie** · 04-19-2013, 07:53 AM

You can copy all the controls from one multipage to another but I've never seen anything for copying/moving a single control.

What do all the command buttons do?

Perhaps you could have something at run-time that adds them to specific pages based on some sort of criteria.

If you did that you would need a class module to handle the click events of the command buttons.

**newbi004** · 04-19-2013, 09:54 AM

Sorry about the delay in responding, Norie.

Below is the code for two selected buttons:

Please Login or Register  to view this content.

and ...

Please Login or Register  to view this content.

There are about 400 buttons in different tabs of the Multipage1 control. I think your suggestion is good, but how do I even start coding that!!!?

**Norie** · 04-19-2013, 10:13 AM

Why do you have all these command buttons?

They appear to do basically the same thing with a few minor changes.

What's the purpose of the form?

Why not use a control that can handle multiple items, for example a listbox or combobox?00