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?
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?
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.
"Mariann" wrote:
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks