static number to cell reference

[Bandito1]

Hello all,

Im using the code below to show or hide a label when the caption of some other label is 145;
the lblDisplaying is used to display how many search results are found. When i don't search on any search term there are 145 search terms and i don't want to display the label then.

If lblSearchResults.Caption = "145" Then
               lblDisplaying.Visible = False

I would like to change this cause the number 145 is variable. Data is added and removed so that number isn't always 145.

I changed it in;

If lblSearchResults.Caption = Shifts_List!C38 Then
               lblDisplaying.Visible = False

In cell C38 is the max number of data that can be searched.

The above code doesn't work, can someone tell me what i do wrong?

 

[shg]

... = Range("Shifts_List!C38").Text

 

[Bandito1]

That's it, thank you very much

 

[shg]

You're welcome.

 

[Rick Rothstein]

... = Range("Shifts_List!C38").Text

You can also do it this way (note the square brackets)...

... = [Shifts_List!C38]

 

[DanteAmor]

Or
... = Sheets("Shifts_List").Range(C38)
or
... = Sheets("Shifts_List").[C38]

 

[Bandito1]

Thank you both for the additional options

 

[DanteAmor]

You're welcome.