Look at the Worksheets collection of the Workbook object.

Edmund

"Go" wrote in message
...
Hi,

I need to create a userform to switch sheets - so it needs to list the
sheets on a listbox and when a user clicks on one of the sheet names on
the
form it will switch to that sheet.

Any ideas as I'm a little stuck.

Joanne