Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeOpen Event and Data Validation annoyance.
Hi,
I have created a generic form which uses drop-down boxes (data validation option List) to select one field which automatically updates other fields using a vlookup function linked to a named range on another sheet. Lots of people use this form and each time enter their name and the date into the form as well as selecting an item from the drop down list. i have written a macro to clean the sheet up ready for a new user, as I am not able to make it read only. i have no problem clearing the name field (cell) The problem I have is I want the drop-down box field to set back to a default value in the list, rather than stay in th eformat it was saved. i am struggling to find code to manage data validation and drop down boxes in this way any ideas? Ant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeOpen Event and Data Validation annoyance.
Set the value of the cell to the value you want the dropdown list (data
validation) to have selected. -- Regards, Tom Ogilvy wrote in message ups.com... Hi, I have created a generic form which uses drop-down boxes (data validation option List) to select one field which automatically updates other fields using a vlookup function linked to a named range on another sheet. Lots of people use this form and each time enter their name and the date into the form as well as selecting an item from the drop down list. i have written a macro to clean the sheet up ready for a new user, as I am not able to make it read only. i have no problem clearing the name field (cell) The problem I have is I want the drop-down box field to set back to a default value in the list, rather than stay in th eformat it was saved. i am struggling to find code to manage data validation and drop down boxes in this way any ideas? Ant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event Procedure - Data Validation List | Excel Programming | |||
Data Validation Listbox and the Worksheet Change Event | Excel Programming | |||
Change event for data validation listbox | Excel Programming | |||
Data Validation & ControlSource & Change event | Excel Programming | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming |