Userform VBA Textbox Calculation

MarkAn · #1 08-15-2014, 05:41 AM

Hi

I have a userform, in the form I have x2 textboxes

Textbox1 and Textbox2. Each of these boxes will contain a value (which can change dependant on what has been entered by the user)

I.e. Textbox1 = 12, Textbox2 = £132.65

Can anyone please help with the VBA that when I click on CommandButton1, it will multiply Textbox1 and Textbox2 and bring back the answer into Textbox3.

Any help will be most appreciated.

MarkAn

macropod · #2 08-15-2014, 06:47 AM

That really is very basic:

Code:

Private Sub CommandButton1_Click()
On Error Resume Next
With Me
  .TextBox3.Value = .TextBox1.Value * .TextBox2.Value
End With
End Sub

MarkAn · #3 08-15-2014, 06:50 AM

Thanks

I've been looking at VBA all day and had a brain freeze, as soon as I posted I realised.....

time for a long break I think

Thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM
Please help with age calculation!!!	Microsoft Idiot	Word	4	10-29-2012 05:54 AM
Display result in textbox based on the input of another textbox	scarymovie	Word VBA	5	05-16-2012 07:05 PM
Number format in Textbox on userform	officeclerk	Excel Programming	2	04-17-2012 01:23 AM