Quote:
Originally Posted by Johnny thunder
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.
|
Well, as I also said in my previous post:
Quote:
|
anything you change in them doesn't take effect until you exit the formfield
|
Quote:
Originally Posted by Johnny thunder
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...
|
If the user chooses "Add", then changes their mind before exiting the formfield, nothing else will have been updated, so selecting "Delete" or re-selecting "Blank" is what will take effect when the finally do exit the formfield. Obviously, though, if the user changes their mind after exiting the formfield, they'll have to re-do the input and redo the exit event before the 'on exit' macro can fire.