Cell reference from TextBox

[Bill D.]

I have a textbox (Textbox2)on my sheet whose value needs to be in a cell
(C42) on the same sheet. This works:

Range("C42") = ActiveSheet.TextBoxes("Textbox2").Text

But it requiers the macro be run to update a change. Is there a way to
have cell C42 automatically update when a new value is entered into the
textbox? Can it be in the form of a formula in C42?

I prefer NOT to use a textbox from the Control Toolbox so as not to have
the click event in the individual sheet module.

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct

 

[Bob Phillips]

Don't think you can. The text box has no linked cell, so if you don't want
events, that is the control toolbox textbox. You could have a UDF, but you
need to hit F9 to re-get the value.



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bill D.]

Thanks Bob,

Guess I'll stick and "UPDATE" button on the sheet to run the macro just
to update the quantity.

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct