Do you have a userform named myform and a listbox on that userform named
mylistbox?

--
Regards,
Tom Ogilvy


"Ctech" wrote:


For i = 0 To .ListCount - 1


on this part of the code I get 'run time error "424", - Object
required'

Does this mean I missing some kind of "references"?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=524722