View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default ListBox Click...

I made a userform that will compile a list of deliquent customers, and put
them in a listbox. I wish to activate a Customer info form that'll display
the information of the customer that you click on from the listbox. I need
help with only one part of this. The listboxe has a 12 character phone number
before every item (ie - 254-254-2542 - James Patterson) I wish to perform the
search based off of the first 12 characters in the string (the phone number)
when I click on one of the items from the list. Can someone give me a clue as
to how to do this.