Hello AiKuchi,
This macro will take the file name from cell "A1" on "Sheet1" and display in it in a Control Toolbox Image control on "Sheet1". The Image control will size itself to match the picture. If you need to change the worksheet name, cell, or name of the control, they are marked in red.
Adding the Macro
1.
Copy the macro above pressing the keys
CTRL+C
2. Open your workbook
3. Press the keys
ALT+F11 to open the Visual Basic Editor
4. Press the keys
ALT+I to activate the
Insert menu
5.
Press M to insert a
Standard Module
6.
Paste the code by pressing the keys
CTRL+V
7. Make any custom changes to the macro if needed at this time.
8.
Save the Macro by pressing the keys
CTRL+S
9. Press the keys
ALT+Q to exit the Editor, and return to Excel.
To Run the Macro...
To run the macro from Excel, open the workbook, and press
ALT+F8 to display the
Run Macro Dialog. Double Click the macro's name to
Run it.
Bookmarks