Hi,
I've created a userform with 10 text box's that the user enters data into then this adds the data to a worksheet. is it possible to get a textbox to calculate a sum(from textbox 9) and show this in textbox10 and allow this to be added to the worksheet ? instead of the user having to manually calculate it and then type the result into textbox10
It is possible
One way is to use an After update macro
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
This assumes that you rename the last TextBox to something like txtTotal, you also need to convert the textbox entry to a numeric variant using CDbl or CLng.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
this is the form spreadsheet i've got what i want to do is for textbox10 to show the result of textbox9 + the calculation to the right of textbox9
TextBox9 appears to require a Date, I haven't a clue what calculation you are referring to.
sorry it the calculation that i written as a label to the right of textbox10
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks