Input Boxes

[Danielle88]

Danielle, I've added your cross post again, Next time your post will be deleted without warning. Please read forum rules


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