| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box VBA script to clear cell in other sheet.
Hi!
I have a vba script that I use for the option "clear cell" from a list box. Now I want it to be able to clear cells in other sheets aswell. My script looks like this: If LCase(.Value) = LCase("clear choices") Then Selection.Offset(1, -2).ClearContents Selection.Offset(0, 0).ClearContents etc.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| Copy sheet and clear cells on new sheet at sametime. | Excel Programming | |||
| Clear all cell in a sheet | Excel Programming | |||
| disable excell sheet cell from VB Script | Excel Programming | |||
Threaded Mode
