6 Ways To Disable Text Or Numbers in Userform TextBox

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

Рет қаралды 24,712

Күн бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 37

@krn14242 4 жыл бұрын

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

@ExcelVbaIsFun 4 жыл бұрын

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

@TanteHela 4 жыл бұрын

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 4 жыл бұрын

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

@rahillakhan3751 6 ай бұрын

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

@wayneedmondson1065 4 жыл бұрын

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 4 жыл бұрын

Glad it was helpful, Wayne! Thanks for sharing!

@eCabinetstipsandtricks 4 жыл бұрын

Thanks, Dan Great Video.

@ExcelVbaIsFun 4 жыл бұрын

Thanks, Scott!👍👍

@almerdavidsolis7287 3 жыл бұрын

Awesome, this is useful for barcode scanning function in userform

@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!

@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!

@eddai84 4 жыл бұрын

Hi Dan, thanks for sharing this useful video.

@ExcelVbaIsFun 4 жыл бұрын

Sure thing! Thanks for thanking me!😀

@ExcelVbaIsFun 4 жыл бұрын

and thanks for watching!

@yaseenbasha7430 3 жыл бұрын

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 2 жыл бұрын

Great Job

@ExcelVbaIsFun 2 жыл бұрын

Thanks!

@lukecassar766 2 жыл бұрын

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)

@W3DRM 4 жыл бұрын

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 4 жыл бұрын

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

@carlo9567 2 жыл бұрын

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 2 жыл бұрын

Here's the new video for you kzfaq.info/get/bejne/jt2ifr1lubOzXas.html Thanks

@manfredkrob3314 5 ай бұрын

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 5 ай бұрын

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

@limitone9564 2 жыл бұрын

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 2 жыл бұрын

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