Add UserForm textbox values

[mkachwee]

Hi

Im trying to add values which have been entered into a user form to get a grand total:

Please Login or Register  to view this content.

I've tried it without converting to Double as shown above too and still no luck.

e.g. adding 567.78 and 12.32 gives me 567.7812.32 in the grand total text box.

Any help appreciated!!!

[mike7952]

This will work. You will need to make sure that all textbox are numeric values

Please Login or Register  to view this content.

[jaslake]

Hi mkachwee

I've code to do just this. If you'll post a sample of your workbook with the UserForm I'll help adapt the code.

[abousetta]

Hi,

This should do it.

Please Login or Register  to view this content.

Just in case you are wondering why I put the "on error resume next" line in, it is because if you leave any of the textboxes empty, then it will give you an error. On the other hand, if you don't want any empty then you can use an error handler to display a message to the user that they are some empty fields.

Good luck.

abousetta

[mkachwee]

Hi abousetta

Thanks the code works perfectly, thanks to all who gave their input

Highly appreciated!!!

[abousetta]

Thanks for the feedback. Glad I could be of assistance.

Good luck.

abousetta