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!