| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving a spreadsheet with form controls | Excel Worksheet Functions | |||
| Controls on Spreadsheet | Excel Worksheet Functions | |||
| HTML controls in spreadsheet | New Users to Excel | |||
| HTML Controls | Excel Discussion (Misc queries) | |||
| Disable controls on spreadsheet | Excel Programming | |||
Linear Mode
