View Full Version : Cell Value in Text Box Control


GUIDO22
12-15-2005, 01:22 AM
Hi
In Excel I need to display a cell value in a text box control - simple....??? :confused:

Can someone tell me how to do this please.

Thank you.
Guido

Jibbadiah
12-15-2005, 03:00 AM
In the properties of the text box put a reference to the cell that you want in the 'linked cell' parameter field. i.e. A1

GUIDO22
12-15-2005, 04:05 AM
In the properties of the text box put a reference to the cell that you want in the 'linked cell' parameter field. i.e. A1
Tried it - doesnt work.... displays it as a string value in the text box

GUIDO22
12-15-2005, 04:08 AM
I 'm sorry - you are quite right - I was using the Text field not the Linked Cell field.

THanks!