Data Validation in textbox on userform

**nav505** · 03-12-2013, 06:25 PM

Hi, I have a userform where a user can enter a postcode in the textbox on the userform, and so the post code is entered in the table once the user clicks OK on the userform. I am just wondering is there a VBA code which can limit the user to only entering 2 characters for the post code, and if he/she enters more than two characters and clicks on OK on the uerform, then a message box pop ups warning that only two characters are allowed.

I am guessing a If statement is needed, yet because I am new to VBA coding I am not quite sure how to construct it. Can anyone please help me?

**cytop** · 03-12-2013, 07:02 PM

ActiveX textboxes on a userform have a MAXLENGTH property - just set it to 2.

**nav505** · 03-12-2013, 07:10 PM

How do I add an activeX textBox on a userform in Visual Basic Editor

**cytop** · 03-12-2013, 07:15 PM

a userform ...enter a postcode in the textbox

It seems you already have. ActiveX controls are the only type that can be added to a userform. Click on the textbox, click F4 to view the properties window and look for MAXLENGTH (The properties are listed alphabetically).