Excel VBA Userform - Numberpad That Works On Multiple Textboxes

Learn to Tell Excel Which control you want to use (the last selected control) with a numberpad!

Fantastic Developer Tools:

[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.

[kevinyork]

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.

[bluex]

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

[aprildu]

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?

[robin]

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

[mohamadsiddeek]

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