I have inserted the link to a cell through controlsource (ie =list!h1). is
that the problem? Is that what is clearing the formula from the cells?
If so is there a way round this/
--
Pilot


"JB" wrote:

Property ControlSource perhaps?

JB
http://boisgontierjacques.free.fr/

On 28 mar, 20:19, Pilot wrote:
I have several texboxes on a userform. Each textbox should display value of a
cell. the problem I am having, is that everytime the userform is opened the
data on each texbox gets displayed only once. i am finding that the formula
on each cell is cleared.
Is there a way to stop that from happening?
--
Pilot