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.

"QuietMan" wrote:

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
--
Helping Is always a good thing