ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I add to a drop down list after I have selected it? (https://www.excelbanter.com/excel-discussion-misc-queries/211386-how-can-i-add-drop-down-list-after-i-have-selected.html)

MEE

How can I add to a drop down list after I have selected it?
 
I have created several drop down lists for my EXCEL document, but want to add
something extra to several cells after I have selected the appropriate drop
down cell. Is this possible?

Basically, can I add extra text to a cell AFTER I have selected something
from the drop down list?

RaulDR

How can I add to a drop down list after I have selected it?
 


"Mee" wrote:

I have created several drop down lists for my EXCEL document, but want to add
something extra to several cells after I have selected the appropriate drop
down cell. Is this possible?

Basically, can I add extra text to a cell AFTER I have selected something
from the drop down list?


Hi!

if you are using excel 2007, uncheck "Show error alert after invalid data is
entered" in the error alert tab.

Hope this help.



MEE

How can I add to a drop down list after I have selected it?
 
Thanks for such a quick reply...I'm actually using Excel 2003, but I'm going
to have a look to see if it's got something similar.

Thanks once again.

Mee.

"RaulDR" wrote:



"Mee" wrote:

I have created several drop down lists for my EXCEL document, but want to add
something extra to several cells after I have selected the appropriate drop
down cell. Is this possible?

Basically, can I add extra text to a cell AFTER I have selected something
from the drop down list?


Hi!

if you are using excel 2007, uncheck "Show error alert after invalid data is
entered" in the error alert tab.

Hope this help.



MEE

How can I add to a drop down list after I have selected it?
 
YESSSS!!! Just tried your suggestion on Excel 2003, and it worked!!! Thank you.

Mee

"RaulDR" wrote:



"Mee" wrote:

I have created several drop down lists for my EXCEL document, but want to add
something extra to several cells after I have selected the appropriate drop
down cell. Is this possible?

Basically, can I add extra text to a cell AFTER I have selected something
from the drop down list?


Hi!

if you are using excel 2007, uncheck "Show error alert after invalid data is
entered" in the error alert tab.

Hope this help.



RaulDR

How can I add to a drop down list after I have selected it?
 


"Mee" wrote:

YESSSS!!! Just tried your suggestion on Excel 2003, and it worked!!! Thank you.

Mee

"RaulDR" wrote:



"Mee" wrote:

I have created several drop down lists for my EXCEL document, but want to add
something extra to several cells after I have selected the appropriate drop
down cell. Is this possible?

Basically, can I add extra text to a cell AFTER I have selected something
from the drop down list?


Hi!

if you are using excel 2007, uncheck "Show error alert after invalid data is
entered" in the error alert tab.

Hope this help.



Welcome :)

Thank you also for the feedback.


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

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