userform calculator

[lpking2005]

need a little help,

I need a simple calculator, so when you put for `example, 4000` in the textbox, it will divide it by a number, `example, 288`. which is in cell (M29)
I need it to do this because the cell will most likely be changing values every once in awhile.

 

[Andrew Poulsom]

Change the names of the controls to suit:

Private Sub CommandButton1_Click()
    TextBox2.Value = Val(TextBox1.Value) / Range("M29").Value
End Sub

 

[lpking2005]

Many Thanks!

It works but when i rename one of them to textbox2, the total does not show up in the secont text box.

i would like the value i enter to stay in textbox1,
then total to appear in text box 2.

 

[lpking2005]

sorry ignore that, its working now!

my silly mistake, all this code i keep looking at today is confusing me.