Cell that is linked to a Textbox, loses formula?
 

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