Check Box Macro

macropod · #1 04-07-2011, 04:39 PM

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.

Johnny thunder · #2 04-07-2011, 04:42 PM

If I was to put the macro "On entry" once the macro runs if the user changes the drop down to another comment to have the macro re-run? I think maybe that was the question I should have asked.

When I do this now it seems like the macro will only run once?

macropod · #3 04-07-2011, 04:46 PM

Quote:

Originally Posted by Johnny thunder

If I was to put the macro "On entry" once the macro runs if the user changes the drop down to another comment to have the macro re-run? I think maybe that was the question I should have asked.

No, that's not viable either. An 'On Entry' macro only runs when you enter the formfield, not while you're doing anything in it.

Johnny thunder · #4 04-07-2011, 04:47 PM

I will try the method code you posted on the other post and see what I come up with.

Thanks again for all your help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
check with condition	karti	Word	2	03-15-2011 06:06 AM
Check whether Follow Up set	konfis	Outlook	0	10-27-2010 11:19 PM
Need Help with Using a Check Box	Nick9589	Excel	1	05-01-2010 09:29 AM
Spell Check	WorkerB	Word	2	11-21-2009 07:22 AM
Check Box in Word	serayam	Word	1	11-06-2008 06:45 AM