I have a cell (B1) that is this:
=IF(A1=1,"You may continue:"," ")
I have a textbox on a userform with the control source to this cell B1, when
I open the form, it shows "You may continue" in the text box, but when the
cell A1 is changed by a listbox on the same form to a number higher than 1,
now this text box becomes blank, which is what I expected. But when the form
is closed, now the formula in B1 is gone, B1 is blank. ...I just simply want
to display the value given by the formula in B1 on my form, but this value
can be changed with other controls on the form... Can this be done?