Excel Expert needed

melsmiff

I am having probelsm with an excel spreadsheet and a clear all button I have created. I can get it to clear normal cells but cells which have scroll bars or option boxes do not clear, or those that have a yes/no list drop down box. Can anyone give me advice? I can send the file if need be as its kind of hard for me to explain!

MercilessKiller

So you have a Macro button that clears information within cells?

When you say you want to clear option boxes.. do you mean delete the option box or clear the information inside it?

Lets say the option box is called optionBox1. You would need to run a function to clear the entry of the option box... so

optionBox1[0] = ""

meaning the first entry in optionbox1 is "" i.e nothing. That code isn't exactly correct though (or it might be..).. but thats the type of thing you need to do to clear information WITHIN an object.

melsmiff

So if my option button is called OptionButton135_Click (I think?) then I would add the code:

Range("D7").Select
Selection.ClearContents
Range("D9").Select
Selection.ClearContents
Range("D11").Select
Selection.ClearContents
Range("D14").Select
Selection.ClearContents
Range("D26").Select
ActiveCell.FormulaR1C1 = "0"
Range("D7").Select
optionButton135_Click [0] = ""
End Sub

f1charlie

You could make it a bit tidier by putting:

Range("D7").Clearcontents