List box VBA script to clear cell in other sheet.

[Guest]

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....

 

[Guest]

worksheets("MySheet").range("A1").offset(1,-2).clearcontents

HTH,
--
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select 'YES' at the bottom of the
post.

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....

worksheets("MySheet").range("A1").offset(1,-2).clearcontents

 

[Guest]

thanks for your help. I will try it when I come home

 

[Guest]

thx gary, it worked great.