Fill A Userform Listbox With Names OF All Open Workbooks

Hi Forum


I am drawing a blank today on this one, can anyone help me as i need to populate a userform list box with the names of all open workbooks to allow my IsError Lookup tool to work on multiple workbooks (As the Type:=8 wont work for this). I know i need it in the Initialize event but i just cant remember the actual code needed!

Anyhelp would be much appriciated.

Cheers

Ah, sorry to trouble you all it just came to me

Please Login or Register  to view this content.

Thanks for any help though.