Calculation based on input from userform textbox
Hi guys
I have an userform with a textbox. Based on the input I would like to make some calculations (the input has to be a number). How can I do this? I think that I have to change the input from text to a number, but I don't know how. I hope some of you guys can help me outThx a lot in advance!
Here is a way to enforce numeric input into a text box.
Any other character will not appear in the text box; it will
be removed by the code after it is typed.
This is how you might convert the text box value for use in a numeric calculation.
Please Login or Register to view this content.
Please Login or Register to view this content.
This will prevent the user from entering anything other than a non-negative integer.
If you want the user to be able to enter any number, you could use this kind of code.Please Login or Register to view this content.
The BeforeUpdate event is to change the text that the user enters into a standard format.Please Login or Register to view this content.
This code will force a "general" format, so that if either "1.23000" or "123e-02" is entered, they will both be shown as "1.23" (after the focus leaves the textbox).
You could change that to any format that you prefer.
Note that the BeforeUpdate event uses the Val function to convert a string into a number.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks