If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting Pictures onto a spreadsheet.
Hi All,
I have been reading many posts about using code to insert pictures from a folder into an area of a spreadsheet and have made them work according to the many people who have posted here. Most posts say that either you enter a name or number in a cell that corresponds to a pic, or use a data validation box to do a lookup. Again, I have made each of these methods work. My question: Can you make it work using an Active X combo box? I am able to make all the code work, but the picture just does not materialize. Alternately are you able to make a data validation box perform an auto complete as the combo box does? Basically I have 8000 enrties of part numbers and with the combo box I can start typing the first numbers or letters and the box jumps to that part of the list. Thanks in advance. Squeaky |
Thread Tools | |
Display Modes | |
|
|