I stink at Excel programming.

Anyways, I have this button which removes employees. And when clicked,
it will display this remove an employee window. Very simple, the user
types in the employee name to remove and then clicks remove and then a
confirmation screen will appear. Only problem is the confirmation
screen won't have access to the employee name which is pretty obvious.
So I would want to send the employee name to that screen, but no matter
what code I try I can't get it to work! Grrr

Here is the code I have:

This is the remove employee menu.

Code:
--------------------

Option Explicit
-----------------

Private Sub removeEmployeeRecord_Click()
confirmRemovalEmployee(employeeName.Text).Show
End Sub

--------------------


The confirmation menu to remove code

Code:
--------------------

Option Explicit
Private Sub cancel_Click()

Unload Me

End Sub

Private Sub confirm_Click(employeeName as String)

Worksheets(employeeName).Delete

End Sub

--------------------


Can someone help me here? And does anyone know of some really good VBA
Excel tutorials? Please do list them.

Thank You.


--
FCC
------------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=557162