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: 470
Default Using Commandbutton for different ranges

I have a worksheet with 12 months of budgets. Across the top are
commandbuttons, one for each month, that I use to have that month brought
into view. I also have two commandbuttons per each month that perform a
sort.
FYI: One sort is to sort by due date and the other button sorts by
separating income entries and expenses.

I was wondering if there was anyway to just have two sort commandbuttons at
the top and somehow they would know which month was being view, thus know the
cell ranges to address for the sort?

Thanks,
Les
 
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
Ref Commandbutton WLMPilot Excel Programming 0 February 20th 08 03:09 PM
Ref Commandbutton WLMPilot Excel Programming 0 February 20th 08 02:51 PM
Commandbutton alvin Kuiper Excel Programming 6 November 27th 05 06:28 PM
CommandButton chris[_12_] Excel Programming 1 April 15th 04 01:01 AM
CommandButton rwebster3 Excel Programming 0 April 14th 04 08:16 PM


All times are GMT +1. The time now is 10:49 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"