code works - need to save

[Ted Roche]

Hutch: Thanks for this. Need a little further help. The validation works on the cell where I want to require the user to provide entry. They are selecting from a validation list (3 choices).

However, I want to save the file with the cell empty and because of the VBA, I can't! How do I get around that?

Thanks again.

Ted

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Shane Devenshire]

Hi,

Please don't break up your posts. Why not add a Workbook_BeforeSave event
which clears the cell(s) before the file closes?

Here is some sample code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Application.Intersect(Target, Range("A1"))
If Not isect Is Nothing Then
'Your code here
End If

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

in message news:[email protected]...