Dialog Box With Macro Buttons (VBA)

[Peter W Soady \(UK\)]

Hi

Can anyone please help me. The scenario is .........

I have a workbook with two worksheets. The first worksheet contains the
"Reporting Form (Range A1:I356) and is constant, it never moves with
additions and deletions there are no cells added or deleted" and the second
worksheet contains the "Data Input Form (currently the range is A1:CW356 and
is constantly moving wider)". Both worksheets are working fine but each
worksheet has around 20 macro buttons along the top which are needed as a
"One Click" to Auto Filter the data required.

What I would like to do is click one button on the worksheet and all these
buttons then pop-up on a sized dialog box until the selection is made then
close the dialog box. The reasons for doing this are that the all the
buttons take up around 1/3rd of my screen vision

Any help provided would be greatly appreciated and I thank you all in
advance

 

[damorrison]

Just to make sure are you talking about the auto filter arrow buttons
that are in the cells??

You may want to make a UserForm that will hold your buttons that would
be the best Idea, another way would be to creat your own toolbar that
would hold your macro buttons, oh another way would be to add the macro
event to the right click menu on the mouse

 

[Peter W Soady \(UK\)]

Thanks

Correct, the majority of the buttons are used by the Auto Filter, however,
not all.

How would I create the toolbar. Although reasonably proficient with VBA I am
a little lost with creating a toobar

 

[Gord Dibben]

Peter

Code for creating a Toolbar can be found at Debra Dalgleish's site.

Code coutesy Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

 

[Peter W Soady \(UK\)]

Gord

Many thanks for that. Saves me a lot of space on my monitor.

Again, cant thank you guys enough

Peter

--