I am currently trying to develope a simple user form that would allow me to
select from a drop down menu an employee's name and month. There also needs
to be a box to enter data. What I would like the form to do when an update
button is clicked, is to read the employees name and the current month that
has been selected and add the new data value to the existing data value
which is located on a separate worksheet. The form would have to find the
row and column based on the names selected from the drop down menus.
Basically when the update button is clicked, the form should read the values
from the employee name and month menus and update that employees data on the
other worksheet. Any help would be great on the matter.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

Other references:

http://j-walk.com/ss/excel/tips/tip84.htm

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

--
Regards,
Tom Ogilvy

"ShagMasterFlex" wrote in message
...
I am currently trying to develope a simple user form that would allow me
to
select from a drop down menu an employee's name and month. There also
needs
to be a box to enter data. What I would like the form to do when an
update
button is clicked, is to read the employees name and the current month
that
has been selected and add the new data value to the existing data value
which is located on a separate worksheet. The form would have to find the
row and column based on the names selected from the drop down menus.
Basically when the update button is clicked, the form should read the
values
from the employee name and month menus and update that employees data on
the
other worksheet. Any help would be great on the matter.