Thread: List box VBA script to clear cell in other sheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Calle Calle is offline
external usenet poster
  
Posts: 70
Default 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....
Reply With QuoteReply With Quote