GuestName = InputBox("Please enter name of guests" & vbCrLf & "First name,
last
name" & vbCrLf & vbCrLf & "separated by a comma", "Enter name")

"Tree*Rat" wrote:

in my input box the question is long and need to split it down. How do i
get this

"please enter name of guests - First name, last name sperated buy a
comma"

to this

"Please enter guests name"
"First name, last name"
""
"Seperated by a comma"




current code
------------
GuestName = InputBox("please enter name of guests - First name, last
name sperated buy a comma", "Enter name")


big thx