Helmut,

Thanks.  I have this working on a small sample form and will try with
my larger project this evening.  I had tried the vbModless route last
night but couldn't keep my form showing.

I think my problem was the standard script that I use for loading and
showing a userform:

Sub Start()
Dim oFrm As UserForm1
Set oFrm = New UserForm1
Load oFrm
oFrm.Show vbModeless 'By addin vbModeless here the form wouldn't stay
open
Unload oFrm
Set oFrm = Nothing
End Sub

Sub Start()
Dim oFrm As UserForm1
Set oFrm = New UserForm1
Load oFrm
oFrm.Show vbModeless
'Unload oFrm - by stetting out this line the form stays open and works
like I want.
Set oFrm = Nothing
End Sub

I then added a Close button to the form:

Private Sub CommandButton3_Click()
Unload Me
End Sub

Is this the right way to do this sort of thing?

Thanks again.