Linking textbox data to a cell or column

Posted by Danielle on January 17, 2002 3:36 PM

Is it possible to link the data displayed in a textbox label for a diagram to a cell or column, so then when the column data is updated, the associated label on the diagram is updated as well>

Thanks
Danielle

Posted by Jacob on January 17, 2002 6:47 PM

Are these on a userform? If so try this:

Sub Userform_activate()
Textbox1.caption = range("A1").value
Or
Label1.caption = Range("M15").value
etc

HTH

Jacob