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 ***
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 ***