#1   Report Post  
Junior Member
 
Posts: 4
Default Picture popup

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.
  #2   Report Post  
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by TheSAguy View Post
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??
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Picture popup

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I insert picture into cell so vlookup can return picture? ah Excel Worksheet Functions 1 May 1st 07 04:38 AM
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 03:48 PM
How do I put single picture into Picture it from a disk? I need help with pictures! New Users to Excel 1 December 2nd 06 05:17 PM
How to extract a picture from an Excel worksheet into a picture fi SARANJAI Excel Discussion (Misc queries) 10 June 12th 05 05:00 AM
Background Picture OR text over a picture greg Excel Discussion (Misc queries) 1 March 30th 05 12:31 AM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"