Hi everyone!
I have a worksheet in which, if a certain value is inputted into cells in D2 and on down the column, then the corresponding cells in Column E and F get greyed out. Is there a code that can say "When this happens, the cursor automatically moves from the current cell to the corresponding cell in Column G?
I have seen something similar on here about that, but I am just not comfortable enough with VBA to even attempt to modify it for what I need.
Thank you all so much!!
There is code to do what you want but it is quite complex. So to avoid any confusion. Is the fact that E & F get greyed out significant?
If there a possibility that you enter something in D 2 and E2 and F2 are not greyed out? What happens then?
I the Interim Paste this code into a Normal Macro module. It is used to declare a Global Variable
Then Right Click on your sheet name at the bottom of excel and select view code.
Please Login or Register to view this content.
Paste this code into the module that opens and then close the module.
Please Login or Register to view this content.
Last edited by mehmetcik; 03-11-2020 at 08:39 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Oh...yes, there is an instance where it would not be greyed out. The cells in E and F would only be greyed out if the cells in D specify "N/A". Otherwise, they would not be greyed out, as there would need to be data in there. Is that just too crazy for me to think that can be handled?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks