ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating Drop Down lists (https://www.excelbanter.com/excel-worksheet-functions/81822-creating-drop-down-lists.html)

Sam151

Creating Drop Down lists
 
I have created a drop down list! The problem I am having is that sometimes I
want to be able to type free form in the cell rather than using the drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam

Biff

Creating Drop Down lists
 
Hi!

Disable the error alert message.

Biff

"Sam151" wrote in message
...
I have created a drop down list! The problem I am having is that sometimes
I
want to be able to type free form in the cell rather than using the drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam




Sam151

Creating Drop Down lists
 
Hi Biff - thanks very much! So simple~!
--
thanks

Sam


"Biff" wrote:

Hi!

Disable the error alert message.

Biff

"Sam151" wrote in message
...
I have created a drop down list! The problem I am having is that sometimes
I
want to be able to type free form in the cell rather than using the drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam





Biff

Creating Drop Down lists
 
You're welcome. Thanks for the feedback!

Biff

"Sam151" wrote in message
...
Hi Biff - thanks very much! So simple~!
--
thanks

Sam


"Biff" wrote:

Hi!

Disable the error alert message.

Biff

"Sam151" wrote in message
...
I have created a drop down list! The problem I am having is that
sometimes
I
want to be able to type free form in the cell rather than using the
drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam







Larry

Creating Drop Down lists
 
Hi sam, I'm larry. Would you mind if I used your drop down code? I don't much
about writing VB but I sure like using it. Thanks, larry

"Sam151" wrote:

I have created a drop down list! The problem I am having is that sometimes I
want to be able to type free form in the cell rather than using the drop
down. Can I do this? If yes, how do I do it?

--
thanks

Sam



All times are GMT +1. The time now is 09:50 PM.

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