Thread: how to reset data entry cells to 0 or empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default how to reset data entry cells to 0 or empty
You'd have to code the cells yourself. E.g.,

Private CommandButton1_Click()
Range("A1").Value = ""
Range("B1").Value = ""
' etc
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bruce" wrote in message
...
Is there a form button a spreadsheet user can use to reset data
entry cells to 0 or empty?

TIA
Bruce



Reply With QuoteReply With Quote