Home |
Search |
Today's Posts |
#1
|
|||
|
|||
User Form Formula ?
Hi
On a user form I have 2 Text Boxes in which to enter cash figures Excluding TAX - on the worksheet these 2 figures enter columns E & G - in column K I have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new Text Box on the user form could it generate the Tax as the formula above and then on clicking Add Iformation Button it would enter column K thus doing away with the formula in column K on the worksheet which is sometimes altered by mistake. Any help much appreciated Cheers ---- Mully |
#2
|
|||
|
|||
Yes,
you could add TextBox3.Text = Format(CStr((Val(TextBox1.Text) + Val(TextBox2.Text)) * 0.175), "#,##0.00") to each textbox change event and dump to the worksheet as with the other amounts Worksheets("Sheet1").Range("K2").Text = Textbox3.Text -- HTH Bob Phillips "mully" wrote in message ... Hi On a user form I have 2 Text Boxes in which to enter cash figures Excluding TAX - on the worksheet these 2 figures enter columns E & G - in column K I have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new Text Box on the user form could it generate the Tax as the formula above and then on clicking Add Iformation Button it would enter column K thus doing away with the formula in column K on the worksheet which is sometimes altered by mistake. Any help much appreciated Cheers ---- Mully |
#3
|
|||
|
|||
Hi Bob
Not long till season kicks off again - can we stop Chelse this year???? Right tried what you suggested on entering data in textbox1 & 2 nothing appears in textbox 3 however on clicking add info - textboxes 1 & 2 info enters their respective cells on the sheet and on the userform text box 3 then shows 0.00 click add info again and it places 0.00 in column K in the next row down - what am I doing wrong Cheers ---- Mully "Bob Phillips" wrote: Yes, you could add TextBox3.Text = Format(CStr((Val(TextBox1.Text) + Val(TextBox2.Text)) * 0.175), "#,##0.00") to each textbox change event and dump to the worksheet as with the other amounts Worksheets("Sheet1").Range("K2").Text = Textbox3.Text -- HTH Bob Phillips "mully" wrote in message ... Hi On a user form I have 2 Text Boxes in which to enter cash figures Excluding TAX - on the worksheet these 2 figures enter columns E & G - in column K I have the formula =IF(SUM(E3+G3)=0"", SUM(E3+G3)*17.5% - If I create a new Text Box on the user form could it generate the Tax as the formula above and then on clicking Add Iformation Button it would enter column K thus doing away with the formula in column K on the worksheet which is sometimes altered by mistake. Any help much appreciated Cheers ---- Mully |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create a formula in Excel that evaluates form information? | Excel Worksheet Functions | |||
Formula for Excel User Name | Excel Worksheet Functions | |||
User Form to Mail Merge | New Users to Excel | |||
User Form Picture | New Users to Excel | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |