Using Cell Result to Identify Form Label

Maryz

Board Regular
Joined
Dec 10, 2002
Messages
197
I have a hundred labels on a user form (Label1, Label2,……Label100) and I’d like to write a procedure where the back color changes depending on a certain criteria. I’d like to use the integer result in a spreadsheet cell to determine which label is selected (ie. “Label22.BackColor = ******” where “22” is the result in a cell). I’ve tried dimensioning variables as labels and concatenating a string with the cell range (L1 = “Label” & Range(“ResultRange”) but I cannot seem to get this procedure to work. Any help is appreciated. Thank you.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Try something like:

UserForm1.Controls("Label" & 22).BackColor =22

You can use variables in place of the 22's.
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Not sure exactly what you are trying to do, but perhaps this will help :-

'------------------------------------------
myvalue = ActiveSheet.Range("A1").Value
myname = "Label" & myvalue
Controls(myname).BackColor = RGB(255, 0, 0)
'-------------------------------------------
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,161
Messages
5,768,542
Members
425,480
Latest member
br400821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top