Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Boxes on Userforms
Patrick
Thanks for reply. Maybe I haven't explained myself properly. On my worksheet I have in cell a3 the formula =a1+a2 and that works fine. I also want to show this data with a userform - so I have my three textboxes textbox1, textbox2 and textbox3 with their controlsource set to the respective cells. When I enter any data, say 3, in textbox1 then textbox3 is calculated correctly to 7. However at the same time the formula stored in a3 becomes 7, not =a1+a2 as it was originally. The result of the calculation, 7, overwrites the formula in cell a3. I have a small workbook here that I could send you. Many thanks. Max "Patrick Molloy" wrote in message ... are you confusing the cell value is versus what the cell forumula is? IF A1=3 and A2=4 then then A3 must be 7 if you sets its formula to A1+A2. thats the point of excel ! setting the source of the textboxes will show the cell's value in the text box. Its not clear to me what you're trying to achieve. If to change the value in the textboxes linked to A1 and A2 then the value in A3 will change, and thus, so will the value in the associated textox. If you enter anything in the textbox3, it will write over what' in A3. To prevent this, set the textbox 'enable'property to False Patrrick Molloy Microsoft Excel MVP -----Original Message----- Hi I'm a bit stuck with textboxes on forms. On my worksheet cell a3 cointains the formula =a1+a2. I then have a form with 3 textboxes. They and their respective control sources a textbox1 sheet1!a1 textbox2 sheet1!a2 textbox3 sheet1!a3 However when I enter anything in textbox1 or textbox2 the formula in my cell a3 is overwritten with result of the calculation. For example if I have 3 in a1 and 4 in a2 I have 7 in a3 not =a1+a2. I've tried locking the textbox, making enable false and making tab stop false. I can do my matchs on the form ie textbox3=val(textbox1)+val(textbox2) but its a bit longwinded. Am I using these completely incorrectly? Thanks Max . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
UserForms - Viewing multiple entries in a text box. | Excel Discussion (Misc queries) | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions |