Thread: newline
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Tree*Rat Tree*Rat is offline
external usenet poster
 
Posts: 12
Default newline

gls858 wrote in
:

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


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

gls858


they will be stored as seperate fields as I will split the input. hence
the comma. But thanks anyway!