Inserting Pictures onto a spreadsheet.
Hi Bill,
Got your email. That's the same file I am trying to modify. It uses a data
validation box whereas I am trying to make it work with an active x combobox.
"Squeaky" wrote:
I'm still kinda new at VBA and still getting used to the many definitions. I
will attempt to make it work by your instructions but I'm better when I can
see a working model.
My email is "squeakysneakers at yahoo dot com"
"Bill Manville" wrote:
Squeaky wrote:
So what cells should I name "LU_Name_FileLoc_XRef"? (in my example)
The table with 2 columns containing picture name in column 1 and picture
path in column 2, just as it is in the contextures example.
I deleted the module and started getting the error again. I renamed the
combobox as iItem and the error went away but I still couldn't make this
work
I don't understand what module you deleted or why, nor why you would rename
a combobox with the name of the integer variable I used to hold its
listindex (+1).
Can you send me your workup so I can study it?
I didn't keep my previous attempt but I will do it again if you want.
Tell me where to send it.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|