Search cells from value of Combo Box
 

Hi,

I am creating created a user form with a Combo Box where the user
selects his name. From that I want a list of cases ( with unique
casenumbers) he has to fill in. After the form is complete it needs to
be added to the correct row.

I was thinking to search for cases where the username matches, and
where a particular field is empty and copy all casenumbers to a range
that can be used as input for a second combobox. The user can then
select his cases, fill them in and the data added to the original row.

I have tried to piece this together by searching. But I am completely
stuck. I hope anyone can help me.


--
tinnef
------------------------------------------------------------------------
tinnef's Profile: http://www.excelforum.com/member.php...o&userid=31043
View this thread: http://www.excelforum.com/showthread...hreadid=507173