combined command button

gdspeare

Board Regular
Joined
Oct 8, 2002
Messages
198
Hello,

I have a page that has 12 frames on it. Each frame has a combobox, a few textboxes and two optoin buttons (none of that matters, just trying to set the stage).

when the form is loaded, each frame is set to a height of 30 and a width of 168. On the combobox_change event the frame height changes to 120 and the width to 240. I have added a command button on each frame to do two things:
1. reset the frame to the orignal size of 30x168
2. change the .visible properties back to true for any of the frames i had to hide for estethic reasons during the origal dimension change.

How can i write a module to call on the commandbutton_click that will:

1. change the .visible for any hidden frames
2. reset the current frame to 30x168

Thanks for the help,
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,136,423
Messages
5,675,765
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top