Inserting Pictures onto a spreadsheet.
Squeaky wrote:
Can you tell me what "InsertPicFromFile _" module you are using?
I downloaded it from contextures yesterday: showfilepicsdemo.zip.
In J3 I
wrote a vlookup so it will display the path of the pic selected in the
combobox, and named this cell "LU_Name_FileLoc_XRef".
Ah - that's the mistake
In the contextures file that name references the 2-column table with
picture names and paths.
My code uses the listindex of the combobox to reference the path from the
appropriate row of column 2 of that table
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|