Inserting Pictures onto a spreadsheet.
Hi Bill,
Yes I have. All of the formulas work, even a hyperlink formula that I click
on will open the pictures as I make my selection in the combobox. It's almost
like the macro does not recognize that the value in it has changed.
"Bill Manville" wrote:
Have you tried linking the ActiveX combo box to a cell (via its
LinkedCell property) and using the cell in the method that you are
using to load the picture?
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|