Thread: newline
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default newline

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