Html controls in spreadsheet
 

have a spreadsheet that has data in in HTML controls.
For example in D4 there is an embed function that contains the control
HTMLText15. It shows 87.3

If I use the function value(D4) I get 0.

If I write a macro with VBA code I can reference HTMLText15.value and
put in cell D4 in another worksheet.
How do I know where the HTMLText controls are. Has anyone worked with
these.
You can reply at
Please no spam

Html controls in spreadsheet
 

Is there a reason you're using these controls ?

To get the position of a control you could try the .TopLeftCell property

Tim


"michael sharpe" wrote in message
ink.net...
have a spreadsheet that has data in in HTML controls.
For example in D4 there is an embed function that contains the control
HTMLText15. It shows 87.3

If I use the function value(D4) I get 0.

If I write a macro with VBA code I can reference HTMLText15.value and
put in cell D4 in another worksheet.
How do I know where the HTMLText controls are. Has anyone worked with
these.
You can reply at
Please no spam