6 Ways To Disable Text Or Numbers in Userform TextBox - ExcelVbaIsFun

[@rahillakhan3751]

Excellent tutorial! Clear, easy to understand and thorough. Thank you!!

[@michaelsmits8677]

now this an instruct the way it should be, to the point and easy to grasp, Dan you are a VBA God to be worshipped

[@ExcelVbaIsFun]

So glad it was helpful to you, Michael!

[@krn14242]

Thanks Dan. This is great content and explains restricting text boxes very well. Great job!

[@ExcelVbaIsFun]

Thanks, Kevin! I appreciate your input, my friend! So glad it's helpful!

[@wayneedmondson1065]

Hi Dan.. excellent.. thanks for the 6 tips on controlling TextBox inputs on Userforms. Was aware of 1 or 2.. glad to now know the others. Thumbs up!!

[@ExcelVbaIsFun]

Glad it was helpful, Wayne! Thanks for sharing!

[@TanteHela]

Thank YOU Dan, what a nice, neat and helpful video (again). Really appreciate the time and effort you put into this. As I'm currently working on a new Userform this truly helps and prevents incorrect entering of values without having to click on the msgbox and setfocus. Looking forward to your next video :-)

[@ExcelVbaIsFun]

Hi TanteHela, Thanks for your kind words! I appreciate it! So glad it was helpful! Dan

[@richardnina79]

Thank you! Could you please show me how to skip a field (text box or date picker) if a previous one met a condition? For example, if the order was not delivered, skip the date of receipt. Thank you!

[@W3DRM]

Hi Dan, yet another great video from you! However, as on old-timer (58+ years of programming - that means I'm really old but still learning new tricks ;)), I have to laugh at your spelling out of ASCII rather than pronouncing it verbally. ASCII code has been around forever and has always been verbalized as "ASK-KEY" rather than spelled-out. that's much easier than spelling it each time you verbally refer to it. Thanks for all of your Excel VBA training videos. I've learned a lot from them over the years. Best regards, Don

[@ExcelVbaIsFun]

HAHA! That's hilarious! Thanks for correcting me and helping me pronounce it, Don. Hope the material was at least helpful😁🤣. Many thanks, again!!

[@almerdavidsolis7287]

Awesome, this is useful for barcode scanning function in userform

[@carlo9567]

Great Job

[@ExcelVbaIsFun]

Thanks!

[@lukecassar766]

I have a userform with a bunch of textboxes that I only want numbers for a decimal in. How do I make the KeyPress event call to a function that validates the key pressed. Rather than repeating the code for every single KeyPress event. (hope I worded that clearly enough)

[@manfredkrob3314]

Hi Dan, thanks for this tutorial. But i have an Issue. I work with Excel 365 german Version. I got Debug with Message "FCompiling errors Variable not defined". Where is my failure? Could you help?

[@manfredkrob3314]

I found it. This Code is functional Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) Dim cVal As String Dim cLen As Integer Dim numSigns As String cVal = Me.TextBox1.Value cLen = Len(cVal) numSigns = String(cLen, "#") If cVal Like numSigns Then 'do nothing Else MsgBox " Nur Zahlen eingeben" Cancel = True 'highlight entire Text With Me.TextBox1 .SelStart = 0 .SelLength = cLen .SetFocus End With End If End Sub

[@eddai84]

Hi Dan, thanks for sharing this useful video.

[@ExcelVbaIsFun]

Sure thing! Thanks for thanking me!😀

[@ExcelVbaIsFun]

and thanks for watching!

[@limitone9564]

how do you format the date one entered in a userform ? it's coming out as 44665 ... when I pull the data from the spreadsheet to view in the userform textbox.

[@ExcelVbaIsFun]

Sure, can we see your code in order to better assist? Thanks Dan

[@yaseenbasha7430]

Wow really a helpful tricks in text box, i need one help from you is how to restrict a input in this format "C-1234567", please help, Thanks in advance

[@carlo9567]

Can you help me with the following please: I created a Userform with 14 Textboxes. T1...T12 for data entry(numeric value only). T13 : Sum of T1...T12 (It’s ok for that one.) How can I get the Average automatically in T14, counting non blank textboxes?

[@ExcelVbaIsFun]

Here's the new video for you kzbin.info/www/bejne/jqjVfI1qibKCY9k Thanks

[@eCabinetstipsandtricks]

Thanks, Dan Great Video.

[@ExcelVbaIsFun]

Thanks, Scott!👍👍

[@pannatpannat4119]

i wan to limit num on 5 digitt can help me plz

[@Husky_Passion]

isnumeric can be tricky, since "10E3" would be a numeric value

[@ExcelVbaIsFun]

True that! Ew - scientific notation! haha. Great point, Husky Passion!

[@carlo9567]

Can someone help me with that please?

[@ExcelVbaIsFun]

Hey Carlo, we answered this with a whole new video. kzbin.info/www/bejne/jqjVfI1qibKCY9k Thanks

[@carlo9567]

@@ExcelVbaIsFun You just got a new subscriber.

[@carlo9567]

SOS

[@ExcelVbaIsFun]

I filmed a solution, it's in editing now. Will let you know when it's ready! :)