Simple math using Text box values in a userform

[Neville Bentley]

Hi Out there,

I am looking for some examples of simple math (Adding, Subtracting, Dividing & Multiplying) using Text box values in a userform.

I have 6 textboxes. 3 of them for data entry and 3 of them for calculating from the other three.

I am not looking to work of any worksheet, it must be done in the user form.

Any Idea's

Cheers Neville

 

[DonkeyOte]

Just noticed you said listbox not combobox -- is it single select or multi select mode ?

 

[Neville Bentley]

Hi there.

It is single select.

Private Sub TextBox9_Exit(ByVal Cancel As MSForms.ReturnBoolean)

On Error GoTo InvalidTypes:
InvalidTypes:
TextBox3.Value = "Non-Numerics in Either Textbox 8 or Textbox 5"

TextBox9.Value = CStr(CDbl(TextBox8.Text) * CDbl(TextBox5.Text) * CDbl(lstUnitP.Text))

End Sub
This what I have at the moment - I am just about to go and step through it.

Cheers

Neville