VBA EXPERTS: I need to make a user form to convert from metric to inches

[bamaisgreat]

Thanks for looking at my post. I need to create a Userform that will pop up on clicking a form control button that has a text box some one can enter in a number in metric and click a button and it convert it to inches.
Example: 145.6 to 5.7323
mm inch

 

[patel45]

sorry, need too much experience to do this

 

[bamaisgreat]

ok, how about anyone that knows anything about VBA. I no very little so everybody is a expert compaired to me.

 

[bamaisgreat]

All I really need is how to make the code for saying value of txtbox1(mm) divided by 25.4 = textbox2 that contains the answere or a label would work too. thanks

 

[Smitty]

Something like this (for Milimeters to Inches):

Me.TextBox1.Value = Me.TextBox1.Value * 0.0393700787

HTH,

 

[bamaisgreat]

Thanks Smitty, i just tried your code and it debuged. The only number that it will let me put in the text box is 0

 

[bamaisgreat]

Smitty what does the Me. do ? Im not sure whats wrong the code you provided seem pretty cut and dry

 

[Smitty]

Thanks Smitty, i just tried your code and it debuged. The only number that it will let me put in the text box is 0

For the Debug error, what error message did you get?

For the second, check the TextBox's properties to make sure that you're not limiting it.

 

[Smitty]

Smitty what does the Me. do ? Im not sure whats wrong the code you provided seem pretty cut and dry

Me just tells VBA that you're referring to a control on the form.

 

[bamaisgreat]

This is the line of code you gave me I adjusted

Private Sub TextBox1_Change()
Me.TextBox1.Value = Me.TextBox1.Value / 25.4
End Sub

The error is Runtime error '13': Type mismatch

Im not sure what in the properties I need to adjust