Sorry To clarify.
I need to run a script when the user exits a table cell which will take the cell that the user left and specify the next cell to goto based upon it.
Why don't you use formfields for your table entry? You'll need to protect at least that part of your document, but formfields have an on-exit from which you can run code, etc.
View-Toolbars-Forms. Check them out. I think you'll like them, 'specially for tables.
If you need to protect just your table, you can insert a continuous section break above the table, and another below it.
If you previously had a one-section doc, it would make it 3 sections now, and you'll want to Tools-Protection, checkmark Forms, hit sections and protect Section 2.
techsupportgirl@home.com
This is a bit tedious for 20+ cells i was hoping for a way to have vba calculate the current cell on exit and use some algorithm to determine what the next should be
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.