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? |
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. |
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. |
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. |
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