textbox1 * textbox2 = textbox3

**cfinch100** · 12-23-2012, 11:30 AM

hi
i have had this previously , but has completely gone think its age ,
i have a userform with numerous text boxes , some are copies so only interested in these 3
tbox1 * tbox2 - tbox 3 ,
as i entered £50 in tb1
entered 2in tb2
tb3 was populated automatically
have tried different versions of this got it once doin me head in now also have populated a userform with a combobox which works but for the life of me cannot get it to populate a textbox1 with data
the combo box pops with 500ton row a and textbox should pop with value in row e
any takers please
as per previous threads im 56 too and its showing have uploaded cranes it is code for userform 1 you will have to go to developer , vb , userform1 and code to view as not userform1.show till got it right
cheers colin

[Private Sub TextBox3_Change()
If TextBox1.Value = "" Then Exit Sub
If TextBox2.Value = "" Then Exit Sub
TextBox3.Value = CDbl(TextBox1.Value) * CDbl(TextBox2.Value)
End Sub]

**cfinch100** · 12-23-2012, 12:26 PM

hi
have now got this that works but need it to be in £ s sterling and not numbers as is with this code , ws is in £s

[Private Sub TextBox1_Change()
If TextBox1.Value = "" Then Exit Sub
If TextBox2.Value = "" Then Exit Sub
TextBox3.Value = CDbl(TextBox1.Value) - CDbl(TextBox2.Value)
End Sub ]

[Private Sub TextBox2_Change()
If TextBox1.Value = "" Then Exit Sub
If TextBox2.Value = "" Then Exit Sub
TextBox3.Value = CDbl(TextBox1.Value) - CDbl(TextBox2.Value)
End Sub]
hope this helps any else struggling
colin

**Norie** · 12-23-2012, 12:49 PM

You can use Format.

 
    TextBox3.Value = Format(CDbl(TextBox1.Value) - CDbl(TextBox2.Value) , "£#.00")

PS Please use 'real' code tags.

**cfinch100** · 12-23-2012, 01:02 PM

hi
says expected end of statement any ideas
colin

**Norie** · 12-23-2012, 01:10 PM

Colin

Did you copy what I posted exactly as it is?

**cfinch100** · 12-23-2012, 01:20 PM

hi norie
yes just redone copied and paste this time no error i forgot the word format
but has not changed just numbers still
cheers colin

**Norie** · 12-23-2012, 01:22 PM

Where did you put the code?

**cfinch100** · 12-23-2012, 01:29 PM

textbox1 and textbox2 where original code was what i put in actually im using 25 and 32 and
39 but 1,2,3 tb will do i can fcheersigure it out from them
cheers col

**cfinch100** · 12-23-2012, 01:59 PM

many thanks again norie found my mistake
cheers

**Norie** · 12-23-2012, 02:02 PM

Colin

Care to share what it was, it is Christmas after all.

**cfinch100** · 12-23-2012, 03:35 PM

hi
yes sorry the code you gave me worked perfect if put into the right textbox, i originally put it in textbox1 and 2 but should have been put into textbox3 the total textbox
textbox1- textbox2=textbox3 easy when you think of me thinks
thanks for help again prob wont be the last i would think watch this space
many thanks
colin

textbox1 * textbox2 = textbox3

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Re: textbox1 * textbox2 = textbox3

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions