I have a user form with several textboxes. The user types
a number in one text box. Based on that input the
contents of another textbox is then determined by setting
the controlsource property to the appropriate cell
reference.

My problem is when I clear that property my cell value
disappears.

Any help would be greatly appreciated.

Cg

Controlsource is a two way street, Change the cell, the textbox changes.
change the textbox, the cell changes.

--
Regards,
Tom Ogilvy

Christy wrote in message
...
I have a user form with several textboxes. The user types
a number in one text box. Based on that input the
contents of another textbox is then determined by setting
the controlsource property to the appropriate cell
reference.

My problem is when I clear that property my cell value
disappears.

Any help would be greatly appreciated.

Cg