Excel 2000 UserForm showing employee history data

[fabianlara]

Hi..
I'd like to create a UserForm (probably within another form)that when activated will display several rows and columns of data for one employee. It would pull the data from a worksheet (in the same workbook) that contains historical data for several employees sorted by an emp id column/field.
I hope this is enough information to go on.

Thank you in advance.

 

[VBAjedi]

Hi!

Do you have a specific question, or are you looking for a general strategy?

VBAjedi

 

[fabianlara]

Hi..
Thanks for getting back to me.

Currently, I run a report from my database that is downloaded to an excel spreadsheet as part of a review process distributed to managers. The report lists compensation history for employees - so each employee can have one or more rows of data.... example below.

ID Name Salary Inc Amt
002 J. Doe 40000 2500
002 J. Doe 37500 2000
002 J. Doe 35500 1000

I'm creating a userform so that managers can select an employee and enter increase recommendations. Additionaly, I'd like to help the manager with his salary increase decision making by providing an additional userform that displays compensation history for his employee.

This compensation history form might be activated with a commandbutton, etc..

Thanks again.

 

[VBAjedi]

The difficulty in using a form to display an indeterminate number of records (raises for a given employee) is that you can't just assign the values to pre-placed labels or something. You will need to use a control like a multi-column list box, which isn't the most visually pleasing way to display this type of information.

What if, instead of a form, you used a PivotTable to show one row for each employee ID. The row could show the number of raises that employee had received (count), the total amount of the raises (sum), and the average raise amount (sum / count). That might summarize the info nicely for your managers, allowing you to use a more simple method (like an input box) to prompt them for a suggested raise amount.

Dunno, just brainstorming here!

VBAjedi

 

[SkipVought]

I agree with Jedi. Why use a form to display tables?

Furthermore, the Pivot Table has a vast potential for summarizing and displaying a multitude of results. Skip,
Skip@theofficeexperts.com