Hello,
I have some kind of a form made in excel. If one cell is a certain value some other cells have to highlight. Conditional formatting doesn't allow this so i'm looking for a VBA sollution but i'm not a very experienced VBA user. My problem is better explained in the attached excel file.
Tx
In Sheet module.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I don't know if i'm doing something wrong but it doesn't work
Then you are indeed doing something wrong.
If i download your file it doesn't work either
Select another value in E1 to change colouring.
Still nothing happening. Thanks for your effort btw
Do you have macro's enabled ?
Yes i have
Did you click on "Enable Content" at the top? I can confirm that bakerman's file works on my end.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Works perfectly also on my machine.Originally Posted by Arkadi
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Run this, then try again.
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