Change Integer to string

[Fire_Chief]

I have a user form that a user inputs a series of numbers in a textbox1 (IE: 77234). I also have a cell with the same number.

When I try to compare ( if textbox1.value = Range ("A1").value .... one is an integer and one is a string and do not match .
How do I change the cell to a string or textbox to an integer.
I will need to change it back after I compare then.

Thank You

 

[jasonb75]

You could try

If Clng(textbox1.value) = Range ("A1").value

to evaluate the textbox string as numeric without changing the type, however if the content of the textbox is not valid to convert to a number then it will result in a runtime error.

 

[Fire_Chief]

Thank you

Works prefect.