August 16th, 2013, 10:01 AM
Excel 2010 VBA
I am trying to do a simple button to picture code however I am new to Visual Basics so I do not know where to begin....Here is a description of my issue:
I am just trying to implement a button click on the excel worksheet so that a picture pops up after a button click.
(Yeah when I meant simple, its that simple) I tried to use the shell function to have the picture pop up from my file on my computer however it did not work.
Any help would be appreciated.
August 16th, 2013, 10:04 AM
Oh and I have the button already on the excel file, but the problem is the module code.
August 16th, 2013, 08:08 PM
One easy way to get this work is to record a macro, then check the code.
Range("B4").Select ' select the cell for the upper left corner of pic's position...
ActiveSheet.Pictures.Insert("D:\stuff\pic.jpg").Select 'and then insert the picture...