Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox linked to a cell
I have several texboxes on a userform. Each textbox should display value of a
cell. the problem I am having, is that everytime the userform is opened the data on each texbox gets displayed only once. i am finding that the formula on each cell is cleared. Is there a way to stop that from happening? -- Pilot |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox linked to a cell
Property ControlSource perhaps?
JB http://boisgontierjacques.free.fr/ On 28 mar, 20:19, Pilot wrote: I have several texboxes on a userform. Each textbox should display value of a cell. the problem I am having, is that everytime the userform is opened the data on each texbox gets displayed only once. i am finding that the formula on each cell is cleared. Is there a way to stop that from happening? -- Pilot |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Textbox linked to a cell
I have inserted the link to a cell through controlsource (ie =list!h1). is
that the problem? Is that what is clearing the formula from the cells? If so is there a way round this/ -- Pilot "JB" wrote: Property ControlSource perhaps? JB http://boisgontierjacques.free.fr/ On 28 mar, 20:19, Pilot wrote: I have several texboxes on a userform. Each textbox should display value of a cell. the problem I am having, is that everytime the userform is opened the data on each texbox gets displayed only once. i am finding that the formula on each cell is cleared. Is there a way to stop that from happening? -- Pilot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox linked to TextBox | Excel Discussion (Misc queries) | |||
TextBox linked to a ComboBox? | Excel Discussion (Misc queries) | |||
VBA cell to textbox | Excel Discussion (Misc queries) | |||
Control Toolbox Textbox and Linked Cells | Excel Discussion (Misc queries) | |||
TextBox control stops displaying linked cell content | Excel Discussion (Misc queries) |