Fire_Chief
Well-known Member
- Joined
- Jun 21, 2003
- Messages
- 690
- Office Version
- 365
- Platform
- Windows
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
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