Could not load an object because it is not available on this machine

Do you use any non-standard controls on the userform such as a calendar?

Are any of them listed with 'MISSING:' in front of them? Do the controls actually work/appear on the form?

Then it would appear that you have another control somewhere that is not working. Impossible for me to say what that might be.

If you can post the workbook (without any data) then I will take a look.

You aren't actually using a Calendar control, you are using a DTPicker instead, so you should be able to remove the reference to the Calendar 2007 control and then save the workbook. See if that helps on the problem machine.

I was at her desk for a while and first I saw 2 selections under VB / TOOLS/ REFERENCES that werent there before. The "MISSING" selections you were talking about. I unchecked those. I also unchecked the calendar control as you instructed. I saved and closed it and re-opened it and tried to use it. Then I got a new message I never saw "COMPILE ERROR METHOD OR DATA MEMBER NOT FOUND" and it pointed to Visual Basic code:

Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Visitor_Data")

'find first empty row in database
iRow = ws.Cells(Rows.Count, 1) _
  .End(xlUp).Offset(1, 0).Row

'check for a type
If Trim(Me.txttype.Value) = "" Then
  Me.txttype.SetFocus
  MsgBox "Please enter a walk-in type"
  Exit Sub
End If

'copy the data to the database
ws.Cells(iRow, 1).Value = Me.txttype.Value
ws.Cells(iRow, 2).Value = Me.txtLastName.Value
ws.Cells(iRow, 3).Value = Me.txtFirstName.Value
ws.Cells(iRow, 4).Value = Me.txtVisitingWho.Value
ws.Cells(iRow, 5).Value = Me.txtCalendar.Value
ws.Cells(iRow, 6).Value = Me.TxtComments.Value

It pointed to the part where it says "txtcalendar.value". So I gave up temporarily. She went to lunch and I will go back to her desk at 2:30. I will try again.

instead of using your own "code tags", use the forums code tags as they actually work :0

the # icon adds code tags.

If she does not have the Windows Common Controls library, then you won't be able to use the DTPicker. If you all have the same version of Windows and Office though, you should have the same controls available.