Inserting Pictures Help Please

C

Chris Hankin

Hello,

Could some one please help me with the following?

I have some jpg pictures in the following folder location:

G:\WLMAEWCSPO\LMU\LOGISTICS PREPAREDNESS SYSTEMS\LOGPREP SYS\V&A AND SCA
ITEM PHOTOS\

I need a macro so that when a user double-clicks on a certain cell as
outlined below, then the file location shown above opens up in a window
enabling the user to select the desired jpg picture and insert the
picture into a cell in my workbook named "Items".

The cells where the jpg pictures may be inserted are:

B2, B21, B42, B63, B84, B105, B126, B147, B168, B189, B210, B231, B252,
B273, B294, B315, B336...etc until the end of column B.

These picture cells do not need to be populated all at once. If the
user wants to add a jpg picture to the spreadsheet, then these cells
mentioned above are the only ones that the user may choose from.

Any help would be greatly appreciated.

Thanks,

Chris.

Live Long and Prosper :)

*** Sent via Developersdex http://www.developersdex.com ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top