| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing value on a userform
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform problem, bordercolor not changing around images | Excel Programming | |||
| Programatically changing picture in UserForm - VBA - Mac OSX | Excel Programming | |||
| changing selected label on userform w/ a variable | Excel Programming | |||
| Changing Thumbnail Pictures in a UserForm | Excel Programming | |||
| Assigning the name of a userform/control to a changing string | Excel Programming | |||
Threaded Mode
