Dialog Box With Macro Buttons (VBA)
 

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

--
Peter W Soady

Dialog Box With Macro Buttons (VBA)
 

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

Dialog Box With Macro Buttons (VBA)
 

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


"damorrison" wrote in message
oups.com...

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

Dialog Box With Macro Buttons (VBA)
 

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

On Sun, 20 Aug 2006 18:34:43 +0100, "Peter W Soady \(UK\)"
wrote:

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


"damorrison" wrote in message
roups.com...

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

Dialog Box With Macro Buttons (VBA)
 

Gord

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

Again, cant thank you guys enough

Peter

--

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


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 18:34:43 +0100, "Peter W Soady \(UK\)"
wrote:

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


"damorrison" wrote in message
groups.com...

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