View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gappodi@gmail.com is offline
external usenet poster
 
Posts: 8
Default 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