Automatically open the userform when the cell value meet 7 digits

[thejas]

Hello Everyone,

Anyone Help me, i want open the userform automatically when the cell A2 having 7 digits number or else the the message
should display like "Please enter 7 Digit".

Thanks in advance.

[Elroy]

Well, as far as I know, without subclassing, you're not going to be able to check the cell on every keystroke. However, you can check it when that cell loses focus. You could just put some code something like the following in the sheet that has your cell A2.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$2" Then
        If Len(Target.Text) = 7 And Not Target.Text Like "*[!0-9]*" Then
            MsgBox "Your text is correct with 7 digits."
        Else
            MsgBox "Your text is not correct, and should have 7 digits."
        End If
    End If
End Sub

That's just an example. I'll let you design your own UserForms, and/or do whatever other work you wish to do.

Enjoy,
Elroy

[thejas]

Thank you so much Elroy.
Perfect it was worked what i want.