Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Buttons and macros?
I have no idea where to start learning VBA and macros and stuff, but
hopefully someone can help me write something up for what I want to do. A B C Item 1 |___| [button] Descriptor in Column A, empty cell in Column B, and a button in column C. I'm hoping theres a way to make it so that every time the button is clicked, the number in the empty cell in coulmnB increases by 1, just a simple tally for every time the button is clicked. I plan on populating a sheet with multiples of this setup, so if theres an easy way to do this, please help. |
#2
|
|||
|
|||
Hi Joe,
Sub TallyHo() Range("B1").Value = Range("B1").Value + 1 End Sub HTH Regards, Howard "Joe" wrote in message ... I have no idea where to start learning VBA and macros and stuff, but hopefully someone can help me write something up for what I want to do. A B C Item 1 |___| [button] Descriptor in Column A, empty cell in Column B, and a button in column C. I'm hoping theres a way to make it so that every time the button is clicked, the number in the empty cell in coulmnB increases by 1, just a simple tally for every time the button is clicked. I plan on populating a sheet with multiples of this setup, so if theres an easy way to do this, please help. |
#3
|
|||
|
|||
Hi, How about something like this: Sub Button1_Click() Range("B1").Value = Range("B1").Value + 1 End Sub I'm not an expert, just trying to help! Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=473967 |
#4
|
|||
|
|||
Sweet, thanks!
-- "L. Howard Kittle" wrote in message ... Hi Joe, Sub TallyHo() Range("B1").Value = Range("B1").Value + 1 End Sub HTH Regards, Howard "Joe" wrote in message ... I have no idea where to start learning VBA and macros and stuff, but hopefully someone can help me write something up for what I want to do. A B C Item 1 |___| [button] Descriptor in Column A, empty cell in Column B, and a button in column C. I'm hoping theres a way to make it so that every time the button is clicked, the number in the empty cell in coulmnB increases by 1, just a simple tally for every time the button is clicked. I plan on populating a sheet with multiples of this setup, so if theres an easy way to do this, please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions | |||
assigning macros to buttons or autoshapes | Excel Worksheet Functions | |||
excel 2003 - macros & buttons | New Users to Excel | |||
How to copy a workbook so the buttons run the macros? | Excel Discussion (Misc queries) | |||
Command buttons & macros | Excel Discussion (Misc queries) |