LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 216
Default creating buttons with a macro

Once a user starts macro1, it should create 5 buttons
during the macro and then assign a different macro to each
button.

For example, once macro1 is finished, there is a
spreadsheet with Buttons 1 - 5 across the top.

Button 1 has a macro to sort by date
Button 2 has a macro to sort by amount
Button 3 has a macro to sort by Customer Number.

I'm having trouble creating the buttons with a macro and
assigning the macro to each button. I also need help in
placing the buttons evenly across the spreadheet.

Any help you can provide to get me started would be
greatly appreciated. Thanks.
 
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
Creating Custom Buttons bauman78 Excel Discussion (Misc queries) 3 August 26th 09 04:23 AM
creating buttons in worksheet Robert Excel Discussion (Misc queries) 1 December 19th 08 07:34 PM
Creating Buttons using the Forms Tool bar. MK Excel Worksheet Functions 1 April 4th 07 03:33 AM
Creating Macro Buttons and formatting Big H Excel Discussion (Misc queries) 0 November 1st 06 10:08 PM
Creating buttons using VBA CT[_2_] Excel Programming 7 September 10th 03 05:36 AM


All times are GMT +1. The time now is 06:24 AM.

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"