Dynamic Labels

[ed.ayers315]

Hello Forum,

I reviewed 7 pages referring to dynamic labels; do not think I found a solution, at least that I understand.

On a user form, I need a number of labels or something that shows the value in the cells of the sheet, the cells contain a vlookup formula that changes value based on a combobox on my form. I need the label or what ever to show the values after the combobox selection is made or changed again; this needs to happen without deleting my formulas or writting over them like text boxes do.

So when LINES_2B1B changes I need the value in d21 of sheet4 "LINES" to show in LabelD21A.

Thanks for any help or guidance!

[vbfbryce]

The attached does something close to what you're looking for (I think). I didn't use a value from a combo box, but the rest of the logic should be fairly similar.

[ed.ayers315]

Thanks

Could I replace the static 7 with > 0 ?
Range("c1") = 7 Then

The same with the 5 with something

[vbfbryce]

I'm thinking you'd want to replace it with the selection in your combo box?

I just toggled back and forth between 5 and 7 as an example.

[ed.ayers315]

Goto you, thanks again.

I'll give it a try.