Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What event is associated with a CHANGE in a validation list box? | Excel Programming | |||
In what version was the change event on a data validation list fixed? | Excel Programming | |||
Worksheet Change Event With Validation List | Excel Programming | |||
Sheet change event and list validation question | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |