newline

  • Thread starter Thread starter Tree*Rat
  • Start date Start date
T

Tree*Rat

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
 
GuestName = InputBox("Please enter name of guests" & vbCrLf & "First name,
last
name" & vbCrLf & vbCrLf & "separated by a comma", "Enter name")
 
Tree*Rat said:
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
Click to expand...

Usually it's best to store the first name and last name as separate fields.

gls858
 
Usually it's best to store the first name and last name as separate
fields.

gls858
Click to expand...

they will be stored as seperate fields as I will split the input. hence
the comma. But thanks anyway!
 
How will your code split these two names (both are friends of mine)?

Joseph Della Rossa (Della Rossa is his last name)

Mary Anne Whitfield (Mary Anne is her first name)
 
Rick said:
How will your code split these two names (both are friends of mine)?

Joseph Della Rossa (Della Rossa is his last name)

Mary Anne Whitfield (Mary Anne is her first name)
Click to expand...
 
Rick said:
Your comment did not come through with your posting...
Click to expand...
No comment other than snide remark I decided to cancel and
I hit the send button by mistake.

gls858
 
I'd be interested in your remark (snide or otherwise)... did my posting not
point out a problem with the OP's approach (and which, in its own way,
backed up your suggestion that the OP should consider putting the names in
separate fields)?
 
Rick said:
I'd be interested in your remark (snide or otherwise)... did my posting
not point out a problem with the OP's approach (and which, in its own
way, backed up your suggestion that the OP should consider putting the
names in separate fields)?
Click to expand...

Nope you are absolutely correct! My comment would have been about the OP
already having his mind made up. Your comment was much more useful since
it gave an example of the problems the OP would face with his method.

gls858
 
Back
Top