Hi
I don't know! But I can suggest you take a look here:
http://www.contextures.com/xlDataVal02.html
Sorry I can't be more help, but the above may point you in the right
direction. Sorry, too, if you've already tried Debra's site.

Cheers.
--
Andy.


"Kevin Willhoit"
<Kevin.Willhoit.1qs32c_1119024305.2233@excelforum-nospam.com> wrote in
message news:Kevin.Willhoit.1qs32c_1119024305.2233@excelforum-nospam.com...
>
> I am working on a project in which one list box will populate the next
> through vlookups. The only problem is that if you change one of the
> boxes previous to another it does not clear them therefore they contain
> false values. Any ideas on how to make the boxes clear when selecting
> any of the previous boxes?
>
>
> --
> Kevin Willhoit
> ------------------------------------------------------------------------
> Kevin Willhoit's Profile:
> http://www.excelforum.com/member.php...o&userid=24413
> View this thread: http://www.excelforum.com/showthread...hreadid=380122
>