I have entered the following code to select cell F7 when I6 equals nothing.
This is done to ensure the person filling out the form does not enter bad info into cell F7.
I'm trying to hold them on this cell F7 until they follow the rules set for them.
Now It always selects F7 regardless of what I6 equals.
Please Login or Register to view this content.
Any ideas?
I have changed the Code to the following.
But still not working.Please Login or Register to view this content.
What you are doing is saying, if a cell (any cell) is selected, is it cell I6? So, if it isn't ... Intersect(Target, Range("I6")) Is Nothing ... then select cell F7. In other words, whatever cell you select, if it isn't cell I6, select cell F7.
But you can't say, If Range("I6") ="" Then Range("F7").Select because, unless I6 does have something in it, it the code will select F7 ... and you won't be able to select I6 to put something in it. Catch 22.
I think, if you want something putting in cell I6, that's what you need to monitor, and that's what you need to select.
The other issue is that you are selecting a cell within a Worksheet Selection Change event handler, so there's a serious danger that you will end up in a loop.
You need to add Application.EnableEvents = False before the select and Application.EnableEvents = True after.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If Range("I6") = "You must have written approval to enter that short of a turn around" Then Range("F7").Select
Worked
Thank you TMS
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks