Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Pictures Help Please
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 a 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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Pictures | Excel Discussion (Misc queries) | |||
Inserting Pictures | Excel Discussion (Misc queries) | |||
Inserting Pictures | Excel Discussion (Misc queries) | |||
Inserting Pictures | Excel Programming | |||
inserting pictures | Excel Programming |