Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ReadOnly TextBox from ControlSource
Hello,
I have a TextBox in a Form that has the ControlSource property set to read values from a Cell which has a formula. I have set Enabled to "false" so that users cannot enter data in the TextBox. (read-only from the cell) Somehow the formula in the linked cell is replaced by the value. Looks like the textbox is pushing the value to the cell. How can I prevent the TextBox to put any value into the LinkedCell. (It should just display whatever value is in the linked cell not not clear the formula) Thankyou. Gap |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox ControlSource | Excel Programming | |||
ControlSource in a userform textbox | Excel Programming | |||
textbox not updating when controlsource cell changes | Excel Programming | |||
Textbox ControlSource Property - Excel 97 | Excel Programming | |||
Problem with TextBox & ControlSource - Please Help | Excel Programming |