Just a typo
Additem s

should be

ListBox1.AddItem s

I tested it with that correction and it worked fine for me. (lightly
tested).

--
Regards,
Tom Ogilvy


"jhahes" wrote:


i tried the code and it gives me this error

sub or function not defined AND

AddItem is highlighted when this happens....

thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=551594