Navigate to worksheet using Ribbon dropdown menu

[jeffreybrown]

I found DropDown.zip on Ron de Bruin's site which adds a dropdown to the ribbon and holds values from a worksheet range. I thought I could use these values to naviagate to a worksheet with the same name. At the end the the procedure there is a MsgBox which returns...

The variable MySelectedItem has the value "Item 11" and now can be used in other code.

...but I get a run-time error 91

Object variable or With block variable not set

Sub wsNavigate()
    Sheets(MySelectedItem).Select
End Sub

When I don't add the above (Sub wsNavigate) the variable returns MySelectedItem = "Item 11"

Any thoughts on how I am not calling the variable correctly to use a sheet navigation or is this the wrong use?

 

[AlphaFrog]

As a test, this works if there is a sheet actually named Item 11

Sub wsNavigate()
    MySelectedItem = "Item 11"
    Sheets(MySelectedItem).Select
End Sub

Make sure the spelling of the sheet name is exactly Item 11 with no trailing spaces. Also make sure MySelectedItem doesn't have a trailing space. You might want to use...

   Sheets(Trim(MySelectedItem)).Select

 

[jeffreybrown]

Thanks AlphaFrog,

A bit of an oversight on my part and you are right I had the sheet name spelled wrong on the tab. Instead of Item 11 I had Item11. Thanks