Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to select the next row every time a CommanButton is pressed
I need to select the next row every time a CommanButton is pressed.
I need to start with row3, select it and copy it. The next time the CommanButton is pressed, it will select the next and copy the next row (Row4) and so on everytime the CommandButton is pressed. This is what I have put together so far, but its not working. Private Sub CommandButton1_Click() Rows("2:2").Select Cells(.Row + 1, 1).Select Selection.Copy End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter button jumps to next cell each time its pressed!!!! | Excel Discussion (Misc queries) | |||
Excel Only Showing # When £ has been pressed | Excel Discussion (Misc queries) | |||
preventing button being pressed | Excel Discussion (Misc queries) | |||
count how many times a button is pressed | Excel Discussion (Misc queries) | |||
Jump to data in a list as first letter is pressed | Excel Discussion (Misc queries) |