Selection.width / .height / .left / .top from cell refor userf
1. Dim iNum as Integer
iNum = Textbox1.Value
2. Textbox1.Value = "77"
CInt(Textbox1.Value) produces an Integer
SpinButton1.Value is a number (type Long), so no conversion is needed.
By the way, you can get the data type of any variable X with
Typename(X).
Hth,
Merjet
|