I am using a user form with a RefEdit input box so that through the
form, the user can pick a cell in the worksheet; the chosen cell's
address then shows up in the RefEdit box.

The selected cell is typically in column C (it's a driver for the
formulas in that line). Column B of the same line is the title (e.g.:
Incremental Sales Growth).

What I'd like to do is that after selecting the cell in column C (and
still in the userform), the title from the B column of the selected
row should appear as a label above the RefEdit input box. In other
words, I'd like a way to refresh the form so that the user knows the
title of the line he has just selected. By the way, the address
selected is usually in a different sheet, so the RefEdit.Text has a
sheet name: Sheet1!$C$23, for example. I can't figure out what the
code is to refresh the label on the form based on the change of the
RefEdit box.

(I've figured out how to show the title the next time I active the
user form. When I press OK on the form, that writes the selected
address to another sheet, which I parse it, and somehow can get the
contents of the B column. When I activate the form again, I use that
to label the RefEdit box.)

Thanks for any advice!