decimals need to go as doubles, so dblValue1=cdbl(textbox1.text) and dblValue2=cdbl(textbox2.text)
then tot will be the sum of the two doubles, tot will need to be a double to.
I'd put in an ISNUMERIC() check on both boxes before running the sub.
decimals need to go as doubles, so dblValue1=cdbl(textbox1.text) and dblValue2=cdbl(textbox2.text)
then tot will be the sum of the two doubles, tot will need to be a double to.
I'd put in an ISNUMERIC() check on both boxes before running the sub.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks