So, I have a worksheet sub that checks the selection of a drop-down box. Once the a selection is made, a certain cell's format will be changed, such as the fill color. That routine seems to work fine, but the cursor stays at the cell that is being formatted. Since this form is being filled vertically, I would like the cursor to go down a row from the drop-down box. How would I achieve that?
Try
Please Login or Register to view this content.
Never use Merged Cells in Excel
You mention a routine
so add this at the bottom of that routine
Please Login or Register to view this content.
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.
Hmmm. Maybe it's my placement of the code you both have suggested, but when I put it at the end of the sub, the cursor goes to one below the formatted cell. I'd like to the cursor to go down from the drop-down box. Here's my current code.Please Login or Register to view this content.
Add this before End Sub:
Please Login or Register to view this content.
Please click the * below if this helps
Thank you, JasperD. Your suggestion works perfectly.
Great, glad to hear it works.
Please mark the thread as solved - (thread tools -> mark as solved).
And just FYI - you can condense your code a bit like below:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks