Require 6 digits in UserForm Textbox

[03856me]

I have many textboxes on a UserForm and the value entered must be 6 numeric digits, how can I do this in my code? I understand how to limit with code to numeric numbers in the Exit event but can't find how to REQUIRE all 6 digits be entered.

 

[jproffer]

In the same Exit Event:

If Len(TextBox1.Value) <> 6 Then
'Do whatever you're doing...force the focus back to the textbox or whatever.

 

[03856me]

This worked perfectly - sometimes I make it too hard. Thanks a bunch.