Hi,

I am trying to create a user form that shows certain values from
specific cells when a specific worksheet is selected.

i.e. the information is summary information in a worksheet relating to
a team of people and their working return (sales).

I currently use a form to input most recent data on each team. Each
worksheet then has a summary section which totals and averages some of
the data.

IS there any way that I can create a form that allows me to use a cbo
to select a team (or worksheet) and as a result shows the summary data
on the form (i.e. saves me from sifting through the workbook and
worksheets!?)

cbo - cboTeam (list that allows me to pick relevant worksheet)

summary data is in Cell H5, H6, H7, I5, I6, I7 and J8

Presumably I can set up txtboxes as spaces to show the values - I have
done this and used the following nomenclature...

TxtH6, TxtH7 etc.

Can anyone help