Command button to clear cell contents

[Rockhopper25]

Hi everyone

can anyone help me with this, im pretty sure it will have been asked before but i cannot find anything for it

i have a spreadsheet with several command buttons on that when i highlight a cell then click a button it fills that cell with a colour

what i also need is to be able to highlight any cell then click a button marked clear that will then clear the contents of that cell

i can do it by changing the colour to white but then it changes the surrounding cell borders to white as well which i do not want

could anyone help me with a code to set this up please


Regards Brian

 

[Fluff]

Hi & welcome to MrExcel.
You can use

Selection.Clear

 

[mikerickson]

Rather the change the .Interior.Color of a cell to white you could set the .Interior.ColorIndex to xlNone to leave the grid lines visible.
But the .Clear code that Fluff mentioned is fastest.

 

[Rockhopper25]

Hi & welcome to MrExcel.
You can use

Selection.Clear

Hi Fluff, thank you for quick reply

Im not sure i have this right but its not working i just get an error when i run script

Sub CommandButtonClear ()
Selection.Clear
End Sub


Regards Brian

 

[Fluff]

What error do you get?