I haven't given up on this, and just read another post here how someone is using a userform and listbox/combobox to insert the text.

I think with a userform. I may be able to have a listing of charts in Column B in Excel, and when the user selects the item, to insert the information from Column C.

I hope to work more on it tonight after getting my son down for the night.