LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Pause during Dialog Box data entry kayabob Excel Discussion (Misc queries) 6 October 20th 05 02:58 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
opening different programs with excel macro buttons shrek Excel Worksheet Functions 0 September 30th 05 12:41 PM
Macro to pause for user input in dialog box kayabob Excel Discussion (Misc queries) 1 June 22nd 05 07:49 PM
how to use the search dialog via a macro? cyrille Excel Worksheet Functions 4 February 17th 05 10:41 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"