- Home
- Software
- Office / Productivity
- Office Suites
- MS Office
- MS Excel
- ONE textbox to act like a calculator
Advertisement
| Hall of Fame |
- 1. zorvek466,195
- 2. rorya444,777
- 3. barryhou...313,940
- 4. teylyn268,579
- 5. saurabh726260,531
- 6. matthews...226,162
- 7. chris_bot...195,712
- 8. brettdj195,525
- 9. patrickab170,172
- 10. WarCrimes151,814
- 11. broomee9133,087
- 12. nutsch131,313
- 13. pari123121,950
- 14. byundt118,584
- 15. jppinto87,437
- 16. krishnakrkc83,676
- 17. TomSchre...65,232
- 18. ahammar53,100
- 19. bromy200453,004
- 20. GrahamSkan48,953
- 21. gowflow45,000
- 22. folderol42,700
- 23. hitsdoshi138,804
- 24. spattewar38,354
- 25. sdwalker38,100
- 1. zorvek11,269,892
- 2. rorya9,343,624
- 3. byundt8,375,896
- 4. saurabh7265,400,777
- 5. matthews...4,274,843
- 6. brettdj3,540,692
- 7. patrickab3,390,909
- 8. jeverist2,922,207
- 9. chris_bot...2,330,474
- 10. barryhou...1,935,295
- 11. roos011,928,098
- 12. webtubbs1,879,010
- 13. mvidas1,545,653
- 14. nutsch1,482,383
- 15. fanpages1,236,922
- 16. MalicUK1,060,396
- 17. ahammar1,000,378
- 18. spattewar798,957
- 19. pari123677,423
- 20. mgh_mgh...649,110
- 21. LoNeRaV...602,049
- 22. WarCrimes592,435
- 23. ture572,551
- 24. david251504,426
- 25. epaclm502,595
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
ONE textbox to act like a calculator
Asked by mcnuttlaw in Microsoft Excel Spreadsheet Software
Tags: excel, enter, textbox
I have a UserForm with multi one-line textboxes for the user to enter their amounts. The users then press a 'calculate' button which a grand total would appear at the bottom of the form.
The users have requested that they be allowed to do simple arithmetic while in any textbox since they may have multiple entries related to the line they are currently on.
In other words, have the textbox mimic an Excel cell. The user will want to add (+), subtract (-), multiply(*) or divide (/) while in that textbox.
So I was thinking that they could prefix their math request with the usual Excel "=" and the userform will then fire off a parsing routine and do the appropriate math. If there are other characters such as parentheses, number signs, etc then MsgBox the user saying the formula is not formatted correctly.
The parsing routine would do the math and place the grand total in the current row's textbox in place of the formula they typed in.
Lets not worry about the form's multiple textboxes. I'm just wondering if this is possible to do while in ONE textbox?
I'm open to other ideas of accomplishing this.
| [+][-]03/09/07 02:01 PM, ID: 18690866Accepted Solution |
Your question has an Asker Certified™ answer! mcnuttlaw verified that this solution worked for them--which means it will likely work for you, too. Click to view the solution free for 30-days now.
