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
Bookmarks