VBA code to tell an object to change colour depending on figure in cell
shouldn't be that difficult this one. But basically need a code to tell an object to change fill colour when a cell changes data.
e.g I want a shape/object to turn red(fill) when the number is 0-49, yellow when the number is 50-69 and Green when the number is 70+
preferably I would like the object to include a word of text when the cell = 100 e.g. "complete"
thanks.
What object, and how is the cell populated?
Remember what the dormouse said
Feed your head
object as in .... 'a basic shape'
the cell will be linked to tick boxes so will vary in a percentage rating.. from 0-100 ... or I could easily just make it display 0.50 - 1 etc
For example:
Please Login or Register to view this content.
This is great thanks, ive edited it to be oval 1 on a20 and it does work.. except.. for some reason it wont change automatically when the cell number changes. it only updates when I click run?
or am I missing something obvious
To be automatic you would need to use the Change event and check is the correct cell changed and therefore the code should be run.
Why not use simply cell conditional formatting. You can get non rectangular shapes by masking the cell with a transparent shape.
starting a new thread about something related, ill call it - aesthetic design, appreciate it if you had a look ,your definitely be able to improve it
in the general thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks