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.
--
Regards,

OssieMac


"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