Thread: [Solved] Check Box Macro
View Single Post
 
Old 04-07-2011, 04:29 PM
Johnny thunder Johnny thunder is offline Windows XP Office 2003
Novice
 
Join Date: Apr 2011
Posts: 10
Johnny thunder is on a distinguished road
Default

Quote:
Simply tabbing out of the formfield will do that.
So is there a way to code in a tab out to the code so it automatically does it.

What I am trying to accomplish is, if a user gets the formand only needs to select all once and then save the sheet and send it back to me I don't want to tell them after selecting the formfield use tab or scroll down with the keyboard, I want it to happen automatically.

And putting the macro "On entry" works but if the change the drop down to "Add" and then change there minds and put "delete" the macro doesnt run the second time. It just runs the "Add" all the way down? Do you know of any fixes? The way I was fixing it was unprotecting the sheet and then re-run the macro in VBA Editor but the user I send this too won't have access to unprotect? Im stuck...
Reply With Quote