Excel VBA Userform - Numberpad That Works On Multiple Textboxes

[@excelisfun]

Thanks for the video!!! Rad as always!

[@Nikonbloke]

I have ben struggling for a couple of days now, but you saved me for giving up on my project. Thank you for this video and for all the other videos that have helped me in other projects ! 💜

[@JLyck]

awesome trick told by an awesome teacher!

[@eCabinetstipsandtricks]

Tanks Dan. This will defiantly come in handy.

[@kevinyork4757]

How about a way to get or create a numeric keypad (virtual) that pops up when you want to enter numeric data in an excel spreadsheet. Having problems with a surface tablet and windows 11 with office 365 business. They virtual keyboard built in seems to be corrupted... and it does not offer just a numeric keypad.

[@bluex5115]

select case would be more funny ? :)) instead of if...elseif .. and more than this when u have same code in more than 1 sub of obj its ez way to create a sub module with code and call it from all buttons .. anyway .. thnaks for what u do..I learned something from you

[@aprildu2056]

This is cool Dan. Thanks for the video as always. If I have lots such buttons, is there a better way than writing commandbutton1_click, commandbtutton2_click, etc. many times? something like commandbutton(I) loop? class module?

[@mohamadsiddeek7912]

Hi Sir, please give me solution by Excel VBA for this regard While adding numbers from top to bottom it will give total again entered some numbers again total will come, but the total has to be combined in one. The first total has to be disappered and avoid the blank row as well in this manner has to be continued whenever need to see total. I wish to apply for this regard by Excel VBA. Thanks in advance

[@robin2701]

When you first open the userform the label has no value yet. You should program a default value.

[@robin2701]

But great vid!

[@cihanaltay884]

The bee puts your tounge

[@davidr505]

Here's a different take on solving this problem. You don't need so much code in the command button click events with this method - drive.google.com/folderview?id=0B4Zn90KkZwstT1hRY3dMNEpVTFU&usp=sharing