Select a random value from list and chg background color.
Posted on 2016-10-10
I have a sheet tab, Sheet1 and in column A has values in it. I would like to (no matter how many values are there) press a button on the sheet that selects a random value from that column and pops it up in a Msgbox. It would highlight that value, so the next time it does a random select it will exclude any that have the background color. So the background colored cell would accumulate, and eventually all in the list will have a background color. When I do and clear all background colors it will start over.