Adding a new drop down box

[Potholes]

Good afternoon Steven


As requested a new thread started

Where or how did you attach this code below to the drop down button please.

Please Login or Register  to view this content.

As this program only deals with stations that are used for a particular type of mode only.

...................................................




Could you please add a drop down similar to " C1 " into " C3 " adding " a " Blank " cell and "ALL".


So in other words if in "C1", "FM" is selected then a call sign is entered into "C2", and that call sign will be
displayed, If any other sheet is entered from the drop down from Wicen through to VKDstar, all
of that sheet will be displayed.

That is why I thought maybe I would need "ALL" in "C3" to trigger a full display of that sheet...

I have copied the existing drop down into C3




Many Many Thanks

Peter

[gue2013]

the content of a dropdown box you can find in menu "Data" / "Data Tools / "Data Validation"
Attachment 625970

via the name manage you find the source
Attachment 625971

Now you can correct the source - increase number of rows by 2. This will add "ALL" and a "Blank"

[Potholes]

Good evening

Re your attachments, I am getting an error that it cannot open them and tto refer to a Admin

[gue2013]

Attachments are only screenshots of my explanation

open the Namemanger. there you will see one named range called "list". related to this list is a range. please correct the range as you need it

[Potholes]

Gue2013

So far I have not been able to find the Namemanager ????? on my Excel

[gue2013]

menu "Formulas" - section "Defined Names"

[popipipo]

find the Namemanager

Or the shortcut:
CTRL F3