Sounds like you are typing letters into the textbox.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen53" wrote in message
...
Hi,

I am having trouble saving my textbox as a number. Here is the format I
am
using..

with ws
.Cells(Choice, 7).NumberFormat = "0"
.Cells(Choice, 7) = CInt(Me.txtDaysOccupied.Value)
end with

It errors out at the CInt statement with a Type Mismatch. I tried
declaring
an integer variable and converting to this as well but I received the same
error message.

What am I missing?

Thanks