danielle88
New Member
- Joined
- Apr 6, 2008
- Messages
- 4
I'm creating a booking form for a boat company (for uni purposes), and i created an input box to enter in the customer code. What i want to happen is when a customer ID code is entered, like C001 for example, i want it to save on a worksheet. Any ideas?
This is my code so far.
Public Sub DisplayInputBox()
Dim x As String
Dim Message As String
Message = "Please Enter in the Customer ID to save this order"
TitleBarTxt = "Save this order"
DefaultTxt = "Enter The Customer ID"
x = InputBox(Message, TitleBarTxt, DefaultTxt)
End Sub
This is my code so far.
Public Sub DisplayInputBox()
Dim x As String
Dim Message As String
Message = "Please Enter in the Customer ID to save this order"
TitleBarTxt = "Save this order"
DefaultTxt = "Enter The Customer ID"
x = InputBox(Message, TitleBarTxt, DefaultTxt)
End Sub
