Referencing an activex object from a cell (Excel)

[csbdeady]

Hi

I have a cell that I want to populate with the value of an activex (text box) that I enter within a worksheet in Excel.

If my textbox is called "hello" I enter "=hello.value" in a cell and expect it to work (as this works in VBA) but it does not.

We've tried using the OnChange event on the activex box to run some vba which populates the cell but this is a bit clunky.

Please can anyone offer a suggestion as to how this can easily be achieved.

Thanks
-Colin

 

[Bowers74]

Enter the Absolute reference to the cell you want to link to the TextBox in the LinkedCell property for the TextBox.

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!