Where is your listbox and where is your code?

If it's on a userform, then the "Me" refers to the userform that holds the
listbox. And Tom's code would be somewhere behind that userform (maybe
userform_initialize).

If it's on a worksheet, then the "Me" refers to the worksheet that holds the
listbox (and code). This is not in a general module. (It might be in the
worksheet_activate event.)



"ajw150 <" wrote:

Tom,

Thanks, seems simple, but cant get it to work! Where does it find the
sheet names? and the code doesnt like the Me part.

Andrew

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson