Control Button to increment by 1 and then select next cell in row to increment that cell

Hi,

I need a macro code (to be used with a control button) that increments a cell value by 1 and then selects the next cell in the row. Upon clicking the button, increments the selected cell by 1 and moves to the next cell in the row. I want the button to increment cells in 5 columns and upon completing the 5th column, it returns to the first cell value and increments by 1 and so on.

Background to this request:

I need to pass a task sequentially between 5 staff, and maintain a count of how many tasks i have passed onto each staff. Right now, i'm manually tracking that in excel.

I've search the forums and could find code to increment a cell value, but couldnt find an example, where upon incrementing, the selection is the next cell in row and the increment is only on the selected row and is a continuous cycle thereafter.

Appreciate your assistance in providing code for this specific requirement.

Best regards,

Hi

Try this. If you aren't in the range A1:E1, then it will do nothing. If you are, then it will increment the cell by 1, then move to the next cell to the right. If you end up in F1, then you will be moved back to A1.

Please Login or Register  to view this content.

rylo

Thank you rylo. your solution worked like a charm.

Thank you also for the added functionality of the code to not do anything if the selection is not in the range. I'm very happy with your solution. Can't thank enough.

Best regards,
Ram