Hi

On a userform, is it possible to have the control tip text for a text
box determined by the actual contents of the box?

The text box in question is next to a label "See also:". It would
contain the name of a state benefit and would fill via a VLOOKUP from a
combobox. I would like the control tip text to contain phone numbers
for the local benefit provider.

I know it can be done by VLOOKUPing to another label/text box, but I'm
being bloody minded and want it in the control tip.

Any advice on how to do so would be much appreciated.

For example, the combo box is selected to "Income Support." The label &
text box would then show "See Also:" "Jobseeker's Allowance" and the
control tip "Phone 01202 333xxx"

TIA

Steve