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

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

little help please

"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