If you've never done any VBA programming and have no other foreseeable
needs for that skill, you are probably going to need more help
integrating this potential solution into your workbook than it's
reasonable to try to give via this forum.

If you have done some other VBA coding and just aren't familiar with
the Worksheet_Change even, I can give you some jump-start code.

As an alternate to either of those, let's fall back and think about
what you are really trying to do. It sounds like you want a data
validation cell that will show your user some good choices, but will
also allow your user to input values that aren't in the data validation
list.

If that's accurate, a ActiveX (not a Forms Control) Combobox can give
you that capability. It can accept a range of cells as the list of
items (and a heading to display from a cell directly above that range
of cells) and the selection from the list OR the user-entered text (or
numeric value) can be linked to another cell. If you can implement your
data entry with that sort of fuctionality, then that's probably your
best course of action.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113317