Template VBA Question, Listbox

[Guest]

Here is what I need to do. I need to enter an address into a document based
on a users selection with a listbox. It drops the information into the
document, which is fine, but then later in the document, I need to grab the
person's name from that information, and insert it elsewhere into the
document. How can I accomplish this task? Any suggestions? It would be
like this, First Last then a comma. I need to grab the first and last,
before the comma. Not all names of course are the same length. Thanks in
advance for any, and all help!

Brian

 

[Graham Mayor]

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm should give you a
few ideas
See also http://www.gmayor.com/Macrobutton.htm which shows how to grab
addresses and parts of addresses from Outlook - the techniques are similar.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>