ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto calculation on a userform (https://www.excelbanter.com/excel-discussion-misc-queries/30363-auto-calculation-userform.html)

Greg B

Auto calculation on a userform
 
Hi all, I am using a userform where I have 5 columns of 15 textboxes in each
row I want to have 2 things happen!

I need textbox 16 to add the totals of textboxes 1 - 15 automatically as
they are updated. also there is textbox 17 which counts the amount of
textboxes used . On a worksheet I would use the "isblank" formula but I
have no idea of what to use on a userform.

If anyone can help me with some code to start on this I can can work out the
rest of the columns.

Thanks in advance

Greg




All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com