Excel - Input mask issue

Latest update on April 26, 2012 at 07:36 AM by aakai1056 .

I would like to assign a custom input mask to a textbox like this:

Issue

"A.44.A.04.04"

Solution

Try this:

Dim lt As Long
lt = Len(TextBox1.Text)
If lt = 1 Or lt = 4 Or lt = 6 Or lt = 9 Then
  TextBox1.Text = TextBox1.Text & "."
End If

Thanks to ccm81 for this tip.

Excel input mask
Excel input bar missing - How-To - Excel
Excel input data from one sheet to another - How-To - Excel
How to change date input format in excel - How-To - Excel
Auto generate serial number in excel based on input value ✓ - Forum - Excel
How to change cell color in excel based on text input ✓ - Forum - Excel

This document, titled « Excel - Input mask issue », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel - Copy row and insert n times

Excel - Using SUMIF function with two criteria

Issue

Solution

Subscribe To Our Newsletter!