Here is a small code that doesn't work, but maybe some can fix it. I have a ClearContents Button that removes the content of a cell that has been CF formatting to change the font to red, but if it's not red, I want to give a little message stating the black font is ok. It goes like this
The above is the actual code, but would like to do it this way.
Please Login or Register to view this content.
Please Login or Register to view this content.
Any help would be appreciated.
Try usingPlease Login or Register to view this content.
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
Since coloring is done by CF we cannot just use Selection.Font.Color because XL won't recognize the color set by that CF.
We need to add DisplayFormat to do so.
Please Login or Register to view this content.
Last edited by bakerman2; 09-18-2021 at 09:03 PM. Reason: Tested with CF
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.
Exactly what I needed. Thanks
TMS, sorry didn't try yours, but bakerman2 work, and thanks anyway
Your welcome and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
You're welcome. Thanks for the rep.
I should read the question properly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks