ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   user-changeable drop-down lists (https://www.excelbanter.com/excel-discussion-misc-queries/141091-user-changeable-drop-down-lists.html)

compu-mom

user-changeable drop-down lists
 
I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!

excelent

user-changeable drop-down lists
 
remove the check-mark on Error-message tab

"compu-mom" skrev:

I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!


Gord Dibben

user-changeable drop-down lists
 
Using Data Validation drop-down list, uncheck "Show error alert after invalid
data has been entered"


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 09:17:02 -0700, compu-mom
wrote:

I have made the drop-down lists using the Validation tool. I have also made
a drop-down list using the combo box from form control. But what I need to
do is to make it possible to either pick from the drop down list or type in
your own response.
Any help would be greatly appreciated!




All times are GMT +1. The time now is 06:28 PM.

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