Textbox linked to a cell

P

Pilot

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?
 
P

Pilot

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Textbox linked to a cell (reposted) 0
Cell that is linked to a Textbox, loses formula? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Textbox font colour change? 6
Bind a textbox to Access data 0
Linking data in MS Word into Excel 5
How do I link a cell in a workbook? 1
TextBox linked to cell????? 4

Top