• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is Conditional Formatting on a shape from Excel 2007 possible?

fred

Member
hi all,


On a spreadsheet I have created 2 radial buttons using "Form Controls". I have also created 2 transparent "Right arrow callout" boxes covering the 2 radial buttons. Currently both "right arrow callout" boxes are showing on the spreadsheet.


Question: How do I set it up in such a way that only the first box would show up if I click on the first radial button whilst hiding the 2nd box, and vice versa? Is it possible to get this done without using VBA?


Thank you very much.
 
Fred

Not possible without some VBA, but luckily it is very simple VBA


Copy the following code into a Worksheet Object in VBA

Alt F11, Double click the sheet you want to apply this to and paste on the right hand window


Then on your Radial Buttons, right click and assign a macro to each as appropriate

Change the Sheet names and Shape names to suit

[pre]
Code:
Sub ShowArrow1()
Set myDoc = Worksheets("Sheet1")
myDoc.Shapes("Right Arrow 1").Visible = True
myDoc.Shapes("Right Arrow 2").Visible = False

End Sub

Sub ShowArrow2()
Set myDoc = Worksheets("Sheet1")
myDoc.Shapes("Right Arrow 1").Visible = False
myDoc.Shapes("Right Arrow 2").Visible = True

End Sub
[/pre]
 
Back
Top