Blank forms help!
Maybe you can select the range of cells to clear.
Then give it a nice name (insert|name|define).
Then when you want to clear those cells, you can:
edit|goto|type in that name (or choose it from the list)
click ok.
Hit the delete key.
Heck, you could even turn that into a small macro and drop a button from the
forms toolbar on that sheet that has the macro assigned to it.
Option Explicit
Sub testme()
Dim resp As Long
resp = MsgBox(prompt:="are you sure you want to clear the input cells?", _
Buttons:=vbYesNo)
If resp = vbYes Then
ActiveSheet.Range("Myinputdata").ClearContents
End If
End Sub
matt wrote:
I have to clear a worksheet except for certain things, so a new bill can be
entered. The trouble is it only deletes the actual combo box that was there
when the macro was recorded any way of getting round it?
Thanks
--
Dave Peterson
|