Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Spreadsheet values on a userform
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
Showing Userform | Excel Programming | |||
Showing a userform | Excel Programming | |||
Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions |