Saturday, January 16, 2010

How do I reference a form control object within an excel formula?

All objects in Forms toolbar can be linked to cells, after linking to cell, you can make a formula that uses that cell.


How to link object to cell?


Right click on the object and select ';Format Control'; %26gt; Control %26gt; Cell link


and change it to the cell address you want





mail me for further info





Enjoy my profile, I am the VBAXLMan

No comments:

Post a Comment