Userform updating


Posted by Mr Peter on January 30, 2002 8:20 AM

Dear All,

1.One basic question, why arent't my userform lists updating although the info in the Sheet is changing.
If I would close the form and open it again the numbers are there.

2.Why can't I have a Controlsource in a textbox referring to a cell with a formula in i a sheet?

What are your comments in this case?

Thanx in advance.

/Mr P



Posted by Juan Pablo G. on January 30, 2002 8:23 AM

>> 1.One basic question, why arent't my userform lists updating although the info in the Sheet is changing.

How are you updating the info on the sheet ? how are they linked ?

>> 2.Why can't I have a Controlsource in a textbox referring to a cell with a formula in i a sheet?

The property is called LinkedCell.

Juan Pablo G.