View Full Version : Sheet Names of XLS within a drop down list
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
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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.