UserForm Listbox Add Worksheets with If Check

**jvbeats** · 12-04-2012, 11:47 AM

Hi working to activate my userform listbox with a list of all worksheets except certain named ones. This is what I have so far...

Please Login or Register  to view this content.

I'm getting an type mismatch error on "If ws.Name <> "SheetName1" Or "Sheet2" Or "This_Sheet Then"

How do I specify which sheets to exclude?

**Norie** · 12-04-2012, 11:50 AM

Try this.

Please Login or Register  to view this content.

**jvbeats** · 12-04-2012, 11:54 AM

thank u. that works. is it possible to do that in an If statement though? why didn't the original one work?

**Norie** · 12-04-2012, 11:57 AM

This is what the If would look like.

Please Login or Register  to view this content.

Re: UserForm Listbox Add Worksheets with If Check