View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DeN DeN is offline
external usenet poster
 
Posts: 15
Default Macro or VB code to hide and unhide Label box

I need your help to create a macro or a Visual Basic code that do the
following: 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. I'm trying a VB code using the if
statement to change the visible property (to False and True) of the Label
box but is not working. I'm not very familiarized with visual basic and Im
not at the level of skills of many of you so please take that in
consideration for any suggestion.

Thanks in advance€¦