Hello everyone.
I have a small table with some letters and with their background color, what i want is :
In a range of cells, if i write one of the letters of the table, automatically the background color of that cell changes. All this in VBA of course.
Here a sample file :
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Yeah it works, nice!
But i would prefer if all this were done io a for loop, is it possible?
Don't understand. Is the data already added and you need to run this once? In your original post you indicate you wish to update as you enter data. This would preclude a loop. Which is it.
No. But now i have a solution that works :
What do you think about this Alansidman?Please Login or Register to view this content.
If it works, then it is ok with me. You are the one that has to work with it.
Why didn't you ask this question in the thread you started earlier here...
https://www.excelforum.com/excel-pro...-on-cells.html
If you had, I would have told you the solution I gave you there (which you said worked) only needed a minor change (shown in red below) to accommodate your new target range...
Note: This code as well as the code I gave you originally allows you to copy/paste values into more than one cell within the target range.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