Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam151
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam151
 
Posts: n/a
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Larry
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a drop down list from another drop down Jody Excel Discussion (Misc queries) 2 March 8th 06 08:14 PM
drop down lists johnny.exe New Users to Excel 2 March 3rd 06 06:35 PM
CREATING MULTIPLE DROP DOWN LISTS IN SAME EXCELWORKBOOK snarled times Excel Discussion (Misc queries) 1 February 19th 06 10:05 PM
Problems with external references when creating a drop down list andreah Excel Discussion (Misc queries) 1 May 19th 05 10:07 PM
creating drop down lists where you can select multiple values Angella Excel Discussion (Misc queries) 2 April 23rd 05 04:58 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"