ExcelBanter - dropdown with option

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

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

- - dropdown with option (https://www.excelbanter.com/excel-discussion-misc-queries/231928-dropdown-option.html)

Aditya

dropdown with option

can i have dropdown with this freedom.

if i donot get item in dropdown menu, i can insert any other desired word.

regards,
aditya

Jacob Skaria

dropdown with option

Dear Aditya

Uncheck 'Show error alert after invalid data is entered' from menu
DataValidationErrorAlert tab

If this post helps click Yes
---------------
Jacob Skaria

"aditya" wrote:

can i have dropdown with this freedom.

if i donot get item in dropdown menu, i can insert any other desired word.

regards,
aditya

All times are GMT +1. The time now is 10:39 AM.