Cheers for the response on this one guys.

In addition, how would I go about getting the finding out which control
was changed by the user?

e.g. if parent changed, then child1 changed, child2 auto-populated,
child3 auto-populated.

I'd like to find out that child1 is the lastbox user interacted with.

ta,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=535458