Hi Everyone,
I was looking to find a way to create a drop down list that contains a checklist, and when the cell is not active it shows only the selected chart items. Does anyone know if there is a way to do this?
Thanks!
Hi Everyone,
I was looking to find a way to create a drop down list that contains a checklist, and when the cell is not active it shows only the selected chart items. Does anyone know if there is a way to do this?
Thanks!
You would probably have to use something like the Worksheet_SelectionChange event to do that. Code it so that when the cell with the drop down is not the Target, it would show your chart items (whatever those are).
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks JLGWhiz, I will give that a try!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks