ExcelBanter - Drop Down Menu

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Drop Down Menu (https://www.excelbanter.com/excel-discussion-misc-queries/231973-drop-down-menu.html)

GooseMA

Drop Down Menu

Hi, I modified the data that appears in a drop down menu but it won't
recognize the new data. Any ideas ?

The drop down menu & the data for the drop down menu are located in the same
workbook, separate worksheets.

thx!

Jacob Skaria

Drop Down Menu

The below post would help.

http://contextures.com/xlNames01.html#Dynamic
--
If this post helps click Yes
---------------
Jacob Skaria

"GooseMA" wrote:

Hi, I modified the data that appears in a drop down menu but it won't
recognize the new data. Any ideas ?

The drop down menu & the data for the drop down menu are located in the same
workbook, separate worksheets.

thx!

Gord Dibben

Drop Down Menu

Check the listrange in Data ValidationSource.

You must change that range if you add more items.

Gord Dibben MS Excel MVP

On Tue, 26 May 2009 10:39:01 -0700, GooseMA
wrote:

Hi, I modified the data that appears in a drop down menu but it won't
recognize the new data. Any ideas ?

The drop down menu & the data for the drop down menu are located in the same
workbook, separate worksheets.

thx!

All times are GMT +1. The time now is 03:43 AM.