Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
newline
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
newline
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
newline
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 (MVP - Excel) "Tree*Rat" wrote in message 6.253... 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! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
newline
Rick Rothstein wrote:
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) |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
newline
Your comment did not come through with your posting...
-- Rick (MVP - Excel) "gls858" wrote in message ... Rick Rothstein wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert newline in cell through formula (excel 2003) | Excel Worksheet Functions | |||
Importing data to excel (newline/carriage return issue) | Excel Discussion (Misc queries) | |||
How to substitute a comma with a newline char using Replace. | Excel Discussion (Misc queries) | |||
How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) |