How do i clear a cell using a command button?

M

Mariann

I need to know how to clear a cell using a command button. I can get it as
far as N/A but is there any way to stop the N/A showing?
 
K

kassie

I don't know where oyu get the N/A from? Create a command button, right
click on it, select View Code, and enter the following: Range(<your range
eg"A1">).ClearContents. Close the VBA editor, click on the Design icon, (the
one with the pencil, triangle and ruler), and click on the button. It will
clear the contents of the cell. I did not deal with naming the button etc
though.
 
Top