Pop up message on creation of new account

[123456]

Hi Help on the following would be most appreciated

How do I write a code that allows the user to enter details into the input box and then once those details are entered, i would like a message to pop up stating that a new account has been created with the details entered.

For eg....name JOHN BROWN ( NEW ACCOUNT)
After the user enters the details into the input box...i would like a message to pop up and state that ....new account for John Brown has been created !

 

[jindon]

Hi

How do you determin "JOHN BROWN" is new account?

 

[123456]

We get new application forms so the user only inputs new clients

 

[jindon]

does this help

Sub test()
Dim res As String
res = InputBox("Enter name for New Account")
If Len(res) > 0 Then
    MsgBox "A new account for " & res & _
            " has been created"
End If
End Sub

 

[123456]

Thank you very much JinDon. It worked like a charm!!!!! Thanks once again