Use a Userform button to insert image in worksheet

[barrymac20]

Hi Guys.

I have a user form that contains a number of buttons, each showing a different picture. I want to click on one of these buttons, which will then close the userform and attach the image to the cursor so i can then click where I want to place the image in the worksheet.
After clicking the location I want it to automatically open another userform that I will use to input data relevant to the picture.

I currently have it that when I click on the button it places the image on the selected cell, but I only want to select the location after I click the button

Any ideas?

Barry

[CK76]

Since you have full path to image file...

May be set public variable to hold image path. Set it when button is clicked.

Then use Worksheet_SelectionChange event, check if variable length > 0, if it is, insert image using variable, and using target position to adjust location.

So something like...

In standard module:

Please Login or Register  to view this content.

In Userform module:

Please Login or Register  to view this content.

In ThisWorkbook module.

Please Login or Register  to view this content.

[barrymac20]

Thanks for your help. Will give this a try.

[romperstomper]

You might also hide the form, use Application.Inputbox(type:=8) to allow selecting a cell and then put the image there before finally unloading.