How To Allow ONLY Numbers and Decimals to a Textbox - [Free Download] - Excel VBA Training

[@Mr_Game_And_Walk]

Thank you for this. I had forgotten about the keyDown event.

[@EricHartwigExcelConsulting]

Great Stuff Dan! Thank you for creating/sharing this video!

[@ExcelVbaIsFun]

Thanks! So glad you enjoyed it!

[@krn14242]

Thanks Dan. Nice to see you talking about "old" vba again. LOL.

[@ExcelVbaIsFun]

Haha. True. I love new things but there's so much that can be done with core elements! Thanks Kevin!

[@Info-God]

A straightforward solution. Thank you very much!

[@ExcelVbaIsFun]

Thank you! And sorry for the delay, but I'm glad you liked it :)

[@Info-God]

@@ExcelVbaIsFun No problem. Actually I might have few things to add to your solution for - Numeric only data entry in a text box. But only if you'd like or think to have a part 2, 3 to your solution.

[@wayneedmondson1065]

Cool! Thanks Dan. Thumbs up!!

[@ExcelVbaIsFun]

Thanks, Wayne! :)

[@thomasfergusen5144]

Great! Thank you very much

[@ExcelVbaIsFun]

Very welcome, thomas!!

[@cbay11]

Hi dan love the work, is there a way you could do a tutorial on how to do a userform macro for selecting documents using option buttons for different worksheets, that firstly needs to be selected, then using a command button to confirm the document selection to open the desired worksheet from the numerous options? Thank you if so!

[@ExcelVbaIsFun]

Hi cbay11, Can you show me a demo workbook or send me a loom video to better describe this process? That may help me visualize what you're needing better. You can reach me at [e-mail] Thanks Dan

[@ruileite6531]

Many thanks (Y) Great work!

[@ExcelVbaIsFun]

Thanks so much!

Hai dan sir ! I have a problem. I want a message when i click my excel file's any cell so what code i run please tell me. Reply plz🙏🏻

[@ExcelVbaIsFun]

Hi Garvit, You can have a message popup when you click on any cell in a workbook, when you click on a specific cell, when you double click something, right click something, or when you change a cell's value. It just depends on what you want it to do. We have tons of lectures on the topic in our course here: www.excelvbaisfun.com/ultimate-excel-pro/

@@ExcelVbaIsFun but sir until i start course, you tell me the code for msg box in excel any cell click..please

[@kenc8411]

I usually try to avoid the vbKey constants wherever I can, unless it's something that doesn't produce a character on screen like BackSpace, Home, Ctrl, etc. I'd use ASC() to trap my visual keys, like in the numeric case, I always use ASC("0") TO ASC("9"), which will trap my numeric inputs whether it's from the NumPad or the top row. Never fails. For decimals or any kind of symbol I will also use ASC("."), ASC("-"), and so on.

[@ExcelVbaIsFun]

That's fantastic!!

[@SmartExpertDesigns]

How to allow fractions and when Enter key pressed then it fills a value on a specific cell

[@CarlFritz24]

FORMAT a Textbox to show NUMBER (in order to be saved as DECIMAL NUMBER) is the REAL NEED of everyone. There are some so TEDIOUS videos on the matter, that we only can get out of them (so showing off they are). Can you just and simply do THAT ? There is a situation here, in your video: what if... instead of a keystroke, the mouse is used (on clicking the button SAVE, for instance).