Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Making command button code "more flexible"

The following macro should work for all CB's.

Sub IncrementCells()
Dim C1 As Range, C2 As Range
Set C1 = ActiveSheet.Shapes(Application.Caller).TopLeftCell
Set C2 = C1.Offset(0, 1)
C2.Value = C2.Value + 1
End Sub

Regards,
Greg Wilson

-----Original Message-----
I have command buttons in one column, that when clicked
add 1 to the value in an adjacent column. As of now the
code is very specific, here is the code for the buttons

in
cells A4 and A5:
__________________________________
Private Sub CommandButton1_Click()
mycount = Range("e4") + 1
Range("e4") = mycount
End Sub

Private Sub CommandButton2_Click()
mycount = Range("e5") + 1
Range("e5") = mycount
End Sub
____________________________________

I would like to make it more flexible so that it adds 1

to
the cell in column e that is in the same row, instead of
having to list the row #. For example, it should add 1

to
the cell e"samerow", instead if creating twenty different
pieces of code like "e6", one for "e7", etc.,

I hope this makes sense.

Thanks.
.

Reply
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
"ClearContents" command halts code Dave O Excel Discussion (Misc queries) 3 January 10th 08 03:39 PM
Programming a "Save as..." command button within Excel DavidHawes Excel Discussion (Misc queries) 2 November 13th 06 02:48 PM
Making a "Filter" button or field Wayne Knazek Excel Discussion (Misc queries) 1 June 9th 06 08:16 PM
inserting a conditional "go to" command on a excel "if" function velasques Excel Worksheet Functions 5 March 10th 06 08:16 PM
Making command button code "more flexible" John Wilson Excel Programming 1 August 4th 03 10:43 PM


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