View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DianeN DianeN is offline
external usenet poster
 
Posts: 8
Default Parsing after multiple selection in drop-down?

Hi,
Using some great code from the "Contextures" website, I'm able to choose
multiple items from a drop-down list, then have them all appear in the same
cell (separated by commas. ) E.g., 4 items might be selected, and all
appear in cell G8:
Commercial, DDA, Treasury, Cash

Now I need to parse them and place each one in the next row down. I.e.,
'Commercial' in cell G8
'DDA' in cell G9
'Treasury' in cell G10
'Cash' in cell G11

Thanks for any help.