ExcelBanter - Drop down menu

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Drop down menu (https://www.excelbanter.com/excel-worksheet-functions/256917-drop-down-menu.html)

George

Drop down menu

How do you edit a drop down menu's location?
--
Thanks,
George

Max

Drop down menu

"George" wrote:
How do you edit a drop down menu's location?
One guess as to the root Q here. Use named ranges as DV sources for better
flexibility. Then you can set the DV up easily to work across sheets as well.
Any joy? hit YES below
--
Max
Singapore
---

Gord Dibben

Drop down menu

Location of the dropdown or location of the list range for the dropdown?

Cut and paste should get you the first.

In DVListSource dialog you should be able to change the list range.

Gord Dibben MS Excel MVP

On Sat, 20 Feb 2010 14:05:01 -0800, George
wrote:

How do you edit a drop down menu's location?

All times are GMT +1. The time now is 02:24 AM.