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

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