Pop up message on creation of new account

123456

New Member
Joined
Dec 9, 2005
Messages
5
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 !
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

jindon

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
does this help
Code:
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

New Member
Joined
Dec 9, 2005
Messages
5
Thank you very much JinDon. It worked like a charm!!!!! Thanks once again
 

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,233
Members
412,709
Latest member
AD04
Top