ExcelBanter

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/126501-drop-down-menu.html)

phil

Drop Down Menu
 
Hi,

Hope someone can help, I am creating a drop down using the Data/Validation
option, which allows me to enter a list to choose for my drop down, but what
I would like to do, is if what I want is not in the drop down, be allowed to
type it in, is this possible.

Thanks

pinmaster

Drop Down Menu
 
Hi,

Yes, under the "Error Alert" tab uncheck the "Show error alert after invalid
data is entered"

HTH
Jean-Guy

"Phil" wrote:

Hi,

Hope someone can help, I am creating a drop down using the Data/Validation
option, which allows me to enter a list to choose for my drop down, but what
I would like to do, is if what I want is not in the drop down, be allowed to
type it in, is this possible.

Thanks



All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com