Defined Name(s)

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
Ok, I'm playing with the idea of interactive charts. I say playing cause I don't have the foggiest idea what the he!! I'm doing. :(

I've downloaded an example of a (what I think) nifty interactive chart that does not use macros, but rather Defined Names and Sheet controls.

After stomping around in the workbook for a few hours I've learned very little. There are no explanations in the workbook, just one hint. I've kind of a slim grasp on how defined Names are working. But what I can't figure out is how you use one defined name to reference another with out saying = "defined Name".

Then, how do you make a cell a list box or a combo box with out actually using list or combo?

The example sheet I downloaded is here

If someone could direct me to some sort of location that would help me understand some of this stuff I've appreciate it.

Thanks.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
thanks nice site.

Also discovered one of the things I was not figuring out was the cells in question were using validation.

Never would have thought to look at that as a possible solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,643
Messages
5,660,051
Members
418,545
Latest member
gsingh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top