✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
This article shows a form in which we have 2 TextBoxes: one to enter only text and another to enter only numbers.
How does it work
-Only numbers: here we use the function Chr (x), where we specify that if the character is less than 48 (0) and greater than 57 (9) then it must be replaced with "", that is, empty.
- Only text: here we use the IsText function to validate that everything that is not text is replaced with "", that is, empty.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Essence by Audionautix is licensed under a Creative Commons Attribution license (creativecommon...)
Artist: audionautix.com/
Негізгі бет Allow just text or numbers on a TextBox on a Excel UserForm using VBA @EXCELeINFO
Пікірлер: 72