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

List box VBA script to clear cell in other sheet.
 

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

HTH,
--
Gary Brown

If this post was helpful to you, please select 'YES' at the bottom of the
post.



"Calle" wrote:

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

List box VBA script to clear cell in other sheet.
 

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

List box VBA script to clear cell in other sheet.
 

thx gary, it worked great.