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