Html controls in spreadsheet

  • Thread starter Thread starter michael sharpe
  • Start date Start date
M

michael sharpe

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 (e-mail address removed)
Please no spam
 
Is there a reason you're using these controls ?

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

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addressing HTMLText object in Spreadsheet VBA Script 3
Deleting specific information 3
Put Formula in VBA 1
Find the correct sheet then find a value on that sheet 8
File Name changes with dates and Deleting Rows of Zeros 0
Need VBA Code to Select text boxes in spreadsheet 2
Need macro that analyses 2 columns . Delets row if same text is fo 3
Open Workbook, Go To Worksheet ABC, Find XYZ In Column B 3

Back
Top