F
fuzzyfreak
The message I am referring to is the "You have an invalid entry, pleas
try again." Message. You OK this and the cell entry has changed t
invalid but you can then click away from this cell and leave “invalid
in the cell – I don’t want them to be able to come away from the cel
unless they have successfully selected a valid entry from the list.
I removed A6 and instead used a named range because I have a few Dat
Validation cells which I want to include in the module.
Further to this though, my biggest problem is that though I got this t
work on a fresh sheet, I then copied it into my project code and i
doesn’t work. The Invalid entry bit works ok but not the first part o
the module i.e. "Your last operation was canceled. " & _ "It would hav
deleted data validation rules."
Your help is very much appreciated.
Fuzz
try again." Message. You OK this and the cell entry has changed t
invalid but you can then click away from this cell and leave “invalid
in the cell – I don’t want them to be able to come away from the cel
unless they have successfully selected a valid entry from the list.
I removed A6 and instead used a named range because I have a few Dat
Validation cells which I want to include in the module.
Further to this though, my biggest problem is that though I got this t
work on a fresh sheet, I then copied it into my project code and i
doesn’t work. The Invalid entry bit works ok but not the first part o
the module i.e. "Your last operation was canceled. " & _ "It would hav
deleted data validation rules."
Your help is very much appreciated.
Fuzz