ElvisSteel
Board Regular
- Joined
- Mar 23, 2009
- Messages
- 122
Hi,
I am using Excel 2007 and I need to provide a set of checkboxes for use in creating a chart.
These will be checkboxes on a worksheet rather than a userform, so I will be using "Developer, Insert, Form Controls" to put the checkboxes on the worksheet.
Rather than fixed text against each box, I would like to have the text driven by a range.
i.e.
I have a list of 5 locations held in a named range "Locations"
I want to provide a checkbox for each of these Locations.
I could just hard code the names against the boxes, but I would like to set it up so that if the first Location is changed from say, "London" to "Manchester", this is automatically reflected against the checkbox.
Is this possible?
Steve
I am using Excel 2007 and I need to provide a set of checkboxes for use in creating a chart.
These will be checkboxes on a worksheet rather than a userform, so I will be using "Developer, Insert, Form Controls" to put the checkboxes on the worksheet.
Rather than fixed text against each box, I would like to have the text driven by a range.
i.e.
I have a list of 5 locations held in a named range "Locations"
I want to provide a checkbox for each of these Locations.
I could just hard code the names against the boxes, but I would like to set it up so that if the first Location is changed from say, "London" to "Manchester", this is automatically reflected against the checkbox.
Is this possible?
Steve
