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 Commandbutton question

I have a worksheet that has 12 different sections (one for each month) used
to enter data to balance a checkbook. I use a commandbutton for each month.
I am not quite sure how to explain what I want to do so I will use the
"normal" code and the the code I have to replace the normal code. Then I
will ask the question.

NORMAL CODE

Private Sub CommandButton1_Click()
Application.Goto Reference:="JAN08"
End Sub

NEW CODE TO DO THE SAME THING

Private Sub CommandButton1_Click()
Dim mnth As String
mnth = CommandButton1.Caption & "08"
Application.Goto Reference:=mnth
End Sub

The caption is the first three letters of each month (JAN, FEB, MAR, etc.)
The cell name for each month is JAN08, FEB08, etc.

Here is my question. Is there a way to determine which commandbutton was
clicked so that I do not have to edit each of the 12 macros and change the
numerical value of each commandbutton within the subroutine?

I was trying to pull out the "name", just as I did with caption, and then do
a RIGHT function and get the number. In the properties of each commandbutton
is "(NAME)". I was not sure if I could access that field.

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
CommandButton Focus Question [email protected] Excel Programming 1 May 18th 07 04:09 AM
how to get commandbutton name Sean Excel Programming 2 October 17th 06 08:49 AM
CommandButton Question Magnivy Excel Programming 5 June 8th 06 05:44 PM
Simpel commandbutton question Andy T via OfficeKB.com Excel Programming 3 September 8th 05 06:39 PM
Simple Question: Hiding a CommandButton JasperBlaas Excel Programming 3 August 9th 04 01:28 PM


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