Are you actually changing something in the list box or are you just selecting
the list box. If you are just selecting the listbox I would use the
MyListBox_Click Event.

If you are changing something in the list box try:

Private Sub MyListBox_Change()
Sheets("Report").Activate
End Sub

or

Private Sub MyListBox_AfterUpdate()
Sheets("Report").Activate
End Sub
--
Cheers,
Ryan


"Martin" wrote:

Hi,

I have a list box and have the following code in the worksheet module:

Private Sub MyListBox_Change()
Sheets("Report").Select
End Sub

My list box is called MyListBox but when I select it nothing happens. All I
want is to go to another sheet after the change occurs.

The only thing I can think is the name of my list box is incorrect but it
does show as MyListBox in the cell name drop down but it doesnt appear in the
defined names. Using 2003.

Can anyone see what I am doing wrong?

Thanks in advance

Martin