Combo Box (Activex control) Auto Change
Hi, hoping someone could help or explain
I have a dashboard which has various combo boxs and data validation lists in it.
What i want is to have a master button that say im running off calendar months, i can choose October and everything will change to October, but because i have the cell links in the combox box controls, it will say that October is period 1 not 10.
But at the same time i want the users to still be able to pick a particular month if they wish.....
So they can put in October from the master button, but if they want to look at July they can still do this within a section of the dashboard. Is this possible?
I can get the data validation to look at the master button/cell but then lose the list of months from the dat list within that cell.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By way2suresh in forum Excel Formulas & Functions
Last Post: 01-03-2013, 03:38 AM
By Ryan_Bernal in forum Excel Programming / VBA / Macros
Last Post: 12-24-2012, 01:38 AM
By Jungl3b0y in forum Excel Formulas & Functions
Last Post: 03-29-2012, 01:21 AM
By whineywright in forum Excel Programming / VBA / Macros
Last Post: 02-26-2011, 03:33 AM
By Billums in forum Excel General
Last Post: 01-19-2006, 09:25 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1