Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a button on my worksheet that activates a userform for data entry. I want to include on this button an event that will clear contents of cells B7:B22 and G7:G22. Also on the same event I want a cell value (AK3) to increment by +1. The number in AK3 is limited to 3 digits so when it gets to 999 it must go to 000 on the next activation. Can somebody please help me with a code for achieving this. Kind Regards gregork ; |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
Code to clear contents | Excel Worksheet Functions | |||
Macro help - copy row, clear, and paste on different sheet | Excel Programming | |||
Clear row contents code | Excel Programming |