Forum Discussion

DreamerMX's avatar
DreamerMX
Copper Contributor
Oct 11, 2021

Masks and Personalization in a "Text Box" of a VBA Form in Excel

Hi everyone! It's my first time to make a form in Excel (I used to use Access) but I'm still new to these topics and haven't found anything about it to use in a vba excel form ... What I need is: ...
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Oct 11, 2021

DreamerMX 

There is no input mask feature for text boxes on a userform, unfortunately.

You can verify and modify the input after it has been entered, for example to convert the input to proper case:

Private Sub TextBox1_AfterUpdate()
    Me.TextBox1 = StrConv(Me.TextBox1, vbProperCase)
End Sub

Resources