microsoft excel training company borough high street london - Excel VBA buttons/images

Hi Jennifer

Thanks for your question. Can I just check that I have understood your question. A user will click the button. This will run the associated procedure and also remove the button. Finally and image will be displayed where the button was position.

Thanks

Andrew

Hi Jennifer

Thank you for your question

If you create the command button and the picture on the form.

In the properties form, set the visible property of the button to true, and the visisble property of the picture to false.

Then double click on the button to open the code window for the on click property.

Then enter the following lines of code

Me.cmd1.Visible = False

    Me.Image1.Visible = True