ExcelBanter - Show / Hide Label

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Show / Hide Label (https://www.excelbanter.com/excel-programming/398701-show-hide-label.html)

O....

Show / Hide Label

How do you show a label if a specific cell is not null. Thanks

O....

Show / Hide Label

I got it...

On Error Resume Next
For Each sh In ActiveWorkbook.Worksheets
sh.OLEObjects("label1").Visible = sh.Range("D3").Value < ""
Next sh

"O...." wrote:

How do you show a label if a specific cell is not null. Thanks

All times are GMT +1. The time now is 12:56 PM.