Hello there,
I have a range of cells (D6:BO42), each cell has a data validation list from a named range (=Selection). Is it possible to scroll through the data validation list by clicking on the cell. For example, if my data validation list (=selection) was made up of four options A,B,C,D, if a cell was empty ( in range D6:BO42) one click = A, two click = B, Three click = C, four click = D then five click returns to empty. Kind of similar to the old school minesweeper game (clear,flagged,mine)?
Hi,
Maybe something like the attached file ?
Regards
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Hello karedog
I like your solution. It's working fine but pls tell me what is the goal of this particular line:
Thanks for your time.
Please Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Hi,Originally Posted by bulina2k
Hello karedog
I like your solution. It's working fine but pls tell me what is the goal of this particular line:
Thanks for your time.Please Login or Register to view this content.
Sorry, that line is unnecessary and can be deleted. When I coding the first time, I don't see the OP requirement that the validation cell can be empty, later when I about to post, I just realized it and suddenly changed my code, but I missed to delete that line.
Regards
Cheers karedog, that works great!
Hi mr_mango81, glad to hear this solve the problem and many thanks for the reps.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks