| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with togglebutton that displays jpg
I have a jpg that when you click the toggle button it appears and when you
click it again it goes away. Can this be done in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with togglebutton that displays jpg
Put a Picture and a Toggle Button on your worksheet. Then, right-click the
sheet tab, choose "View Code" and paste the following code in that module: Private Sub ToggleButton1_Click() Me.Pictures("Picture1").Visible = Me.ToggleButton1.Value End Sub Change "Picture1" to the name assigned to the picture object. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "caj" wrote in message ... I have a jpg that when you click the toggle button it appears and when you click it again it goes away. Can this be done in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with togglebutton that displays jpg
Thank You. Thank you. That worked GREAT! Thanks again.
"Chip Pearson" wrote: Put a Picture and a Toggle Button on your worksheet. Then, right-click the sheet tab, choose "View Code" and paste the following code in that module: Private Sub ToggleButton1_Click() Me.Pictures("Picture1").Visible = Me.ToggleButton1.Value End Sub Change "Picture1" to the name assigned to the picture object. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "caj" wrote in message ... I have a jpg that when you click the toggle button it appears and when you click it again it goes away. Can this be done in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get 00 or 01 from XML to Excel it displays as 0 or 1? | Excel Discussion (Misc queries) | |||
| Number displays | New Users to Excel | |||
| Month always displays as Jan | Excel Worksheet Functions | |||
| Difference From displays #N/A | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
