| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I control linked cell property value in a copied ActiveX contr
I need to copy an ActiveX control approximately 200 times in 1 worksheet (not
form). The LinkedCell property value does not change when I copy and paste - so I end up with 200 controls pointing to the same cell. This is a pain to edit. The control is invoked with the following syntax =EMBED("Forms.ScrollBar.1",""). It "smells like I should be able to expose that cell address so a copy might work but I can't find any reference to the EMBED on line or in 6 books. Any help or redirection would be much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Adding a control button to insert a date in the active cell. | Excel Discussion (Misc queries) | |||
| Footnote wizard linked to cell content | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| resize control checkbox with cell | Excel Discussion (Misc queries) | |||
Linear Mode
