Blank forms help!

M

matt

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
 
D

Dave Peterson

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
 
Top