PDA

View Full Version : Sheet Names of XLS within a drop down list



vra
03-13-2007, 09:42 AM
Hi,

Could somebody tell how to create a drop down list in XLS and populate dropdown list with all sheet names within an excel file and to navigate to the sheet based on the dropdown list selection?

Thanks
v.r

Bob Phillips
03-13-2007, 10:26 AM
Here is an example

vra
03-13-2007, 11:14 AM
Hi,

Thanks a lot for the prompt response. When i tried the drop down list, it gave a run time error 9 : Subscript out of range error.

I am very new to coding in XLS. could you pls. help how to rectify this error?

thanks
v.r

Carl A
03-13-2007, 01:23 PM
Change the ComboBox1_Change() to a click event

Private Sub ComboBox1_Click()
ThisWorkbook.Sheets(Me.ComboBox1.Value).Activate
End Sub

That worked for me :yes

vra
03-13-2007, 02:02 PM
Thank you all for your quick responses. I think this is the only forum in which i got such a quick response.

have a great day to you all..

regards
vr