Combo box using named range stops working - reference not valid

GDH

Board Regular
Joined
May 1, 2011
Messages
128
Hi all

I am creating a dashboard - I started by creating combo box which was linked to a named range.
I had no trouble creating the input range using a name in the format control dialog box of the combo box - pressed F3 and the list of names came up.

The combo box has stopped working now - and when I try to fix it it says "Reference is not valid". I try to press F3 but the name list no longer comes up - if I type manually it doesn't work.

I have tried including the Sheet name prior to the named range but this also has not helped.
The combo box and named range are on different sheets.

I am using Excel 2013.

Is there anyone who might know what is going on here?

Thanks
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

JamesW

Well-known Member
Joined
Oct 30, 2009
Messages
1,197
Hi,

Can you please post your code (using
Code:
 tags) ?
 

Watch MrExcel Video

Forum statistics

Threads
1,126,982
Messages
5,621,964
Members
415,869
Latest member
LWSkinner

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