Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You will need to find the name of the label (sleect label, look at the name
box) and define this in the macro. To install, right click on sheet tab, view code, paste in. Private Sub Worksheet_Calculate() If Range("A1").Value = "Meets" then Me.Shapes("Label 1").Visible = True Else Me.Shapes("Label 1").Visible = False End If End Sub -- Best Regards, Luke M "Den" wrote in message ... Sorry but I'm not very familiarized with visual basic so I will try to be more clear. Basically I have a cell with a macro that shows "Meets" or "Does not Meets" depending of the result of other cell. That I'm trying to do is a macro or visual basic code that display a Label box when "Meets" is showed and hidden it when "Does not Meet" is showed Again I will appreciate any help from you "Luke M" wrote: 'Right click on sheet tab, view code, copy and modify to suit: Private Sub Worksheet_Calculate() Me.Shapes("Label 1").Visible = Range("A1").Value End Sub -- Best Regards, Luke M "Den" wrote in message ... I need a macro or code that show or hidden a Label box when a condition in a cell X is true or false. A will appreciate any help from you . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |