ExcelBanter - Picture popup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Picture popup (https://www.excelbanter.com/excel-discussion-misc-queries/188530-picture-popup.html)

In Excel, What will the code be to display a picture on the screen if a button is pressed?

I have a button, if pressed, needs to open a MsgBox or something displaying a picture.

Thanks.

Quote:

Originally Posted by TheSAguy (Post 670076)

In Excel, What will the code be to display a picture on the screen if a button is pressed?

I have a button, if pressed, needs to open a MsgBox or something displaying a picture.

Thanks.

Anyone please??

I put a button from the Forms Toolbar on the worksheet.
I added a picture named "Picture 1" right near that button.

I assigned this macro to the button:

Option Explicit
Sub testme()
Dim myPict As Picture
Set myPict = ActiveSheet.Pictures("Picture 1")
myPict.Visible = Not myPict.Visible
End Sub

Clicking the button toggles the visibility of the picture.

TheSAguy wrote:

In Excel, What will the code be to display a picture on the screen if a
button is pressed?

I have a button, if pressed, needs to open a MsgBox or something
displaying a picture.

Thanks.

--
TheSAguy

--

Dave Peterson