Help with Label
 

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

Help with Label
 

'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

Help with Label
 

Sorry but Im 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 Im 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


.

Help with Label
 

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


.