Input/combo box

[QuietMan]

Does anyone know how to do this (code) using a input/combo box

The user need to either select and excel worksheet to update (list of
worksheets is a range on another excel worksheet) or all worksheets

From the input box, it would ask if to update all worksheets (yes no)
if no it would bring up the another input box with the range of sheets to
select

Thanks

 

[slarbie]

Instead of dropdowns, how about a user form with a series of checkboxes, one
for each sheet in the workbook? The checkbox label is the name of the
associated sheet. One checkbox at the top as a "select all" option, with a
change event that sets all the others to true (or false when it's unchecked).
Then an "OK" button that runs the update routine for each checked box, using
the label caption as the worksheet name on which to perform the update.

 

[OssieMac]

Do you mean if not all sheets then from the range of sheets you want to be
able to select multiple sheets or just one sheet?

If the latter then you could just have a combo box and have the first option
All Sheets otherwise the user selects an individual sheet. The code can then
handle the users selections.

You could also use a List box similar to above but set Multi select so the
user can make multiple selections. It can be coded so that if All Sheets is
one of the selections then any other selections are ignored.