Question about toggle selections?

[OneofLittleword]

First off hi...

I was wondering if there is a way to have a toggle drop box to list th
names of all sheets listed in my workbook.

e.g i want all the sheet names listed in the box so that what ever wa
entered in the next cell, to be able to research what was selected i
the first cell.

i want the user to select the option by a drop down button.


TI

 

[BrianB]

In the absence of other replies ... the context/meaning of your questio
is not clear.

Presumably you mean a Combobox/Dropdown but do not indicate whether i
a worksheet or user form.

Whatever you use will require a list of sheet names either type
manually or via a macro like this, which refers to a combobox in a use
form (here called "FindForm") :-

'------------------------------------------------------------
Sub ReSetSheetCombo()
FindForm.SheetCombo.Clear
For Each ws In ThisWorkBook.Worksheets
FindForm.SheetCombo.AddItem (ws.Name)
Next
FindForm.SheetCombo.ListIndex = 0
End Sub
'------------------------------------------------------------------

 

[OneofLittleword]

Thanks,

That is what I was looking for.