Trying to change tab color with a worksheet change vba. It works if I eliminate the first if line and last end if. But I need the first if command or it causes other issues.
HTML Code:
Thanks,
Madison
Trying to change tab color with a worksheet change vba. It works if I eliminate the first if line and last end if. But I need the first if command or it causes other issues.
HTML Code:
Thanks,
Madison
Ok, I can see its getting kick out from that first line but how do I change that?
Hello enhydra,
It is hard to tell, without a sample Workbook. Taking a wild guess, please try;
Regards.Please Login or Register to view this content.
Last edited by Winon; 10-09-2017 at 01:04 PM. Reason: Corrected Code
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi allPlease Login or Register to view this content.
Last edited by leelnich; 10-09-2017 at 12:35 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
I now get "End if without block if".
Oops, Sorry!
Just delete the End If before End Sub.
OK, working now. Thanks
And also sorry, I missed the single line/exit sub thing (not my favorite construction). My post #4 code is now updated.
Hi enhydra,
Thank you for the feedback.
You don't however state which contribution solved your issue, but you are welcome. Glad your issue has been solved.
Regards.
I used yours Winon. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks