#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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

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
Dropdown box display only data dependent on another dropdown box? Chris Excel Worksheet Functions 8 August 5th 08 05:01 PM
Can a dropdown list option add color/time to a range? Outbacker Excel Discussion (Misc queries) 1 March 22nd 07 09:22 PM
Data Validation dialog box NO in-cell dropdown option Paul B Excel Discussion (Misc queries) 3 October 19th 06 12:16 AM
How do I change the cell colour per dropdown option? Emma962 Excel Discussion (Misc queries) 1 August 11th 06 03:06 PM
offer dropdown options based on another dropdown Conor Excel Discussion (Misc queries) 2 January 13th 06 04:28 PM


All times are GMT +1. The time now is 03:33 PM.

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

About Us

"It's about Microsoft Excel"