Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy macro assigned buttons in an array
I would like to assign a macro to a button to add 14 days to a date in a cell
in the same row. But the catch is I would like to have 5000 rows with 5000 buttons only update the cell in it's row. Any help would be greatly appreciated. |
#2
|
|||
|
|||
You might want to try a Worksheet_SelectionChange event. This one will add
14 to what ever is in column b and place it in column c when you click a cell in column a. You could use formating in colmn a to simulate buttons Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 And Target.Count = 1 Then Target.Offset(0, 2) = Target.Offset(0, 1) + 14 End If End Sub "Phatboy_D" wrote: I would like to assign a macro to a button to add 14 days to a date in a cell in the same row. But the catch is I would like to have 5000 rows with 5000 buttons only update the cell in it's row. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - - Automation | Excel Discussion (Misc queries) | |||
How do i print out my spreadsheet with macro buttons? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
copying text into a macro | Excel Worksheet Functions |