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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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