Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Pause during Dialog Box data entry | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
opening different programs with excel macro buttons | Excel Worksheet Functions | |||
Macro to pause for user input in dialog box | Excel Discussion (Misc queries) | |||
how to use the search dialog via a macro? | Excel Worksheet Functions |