Skylark_za,

I think you should try using this code instead...

Sub EnterData()
frmPartLoc.Show
End Sub

I have never had to use "frmPartLoc.Show FALSE" to get a user form to
show...not even sure what the FALSE part even does for that
matter...hope that works.

-Todd

skylark_za wrote:
Please could somebody tell me how I would create a control to run the
userform that I have created for an Excel spreadsheet (Excel 2002).

I have tried using
frmFormName.Show False

but this gives me the following debug message
Sub EnterData()
- frmPartLoc.Show False
End Sub

Any insight as to what I may be doing wrong will be appreciated.

Thanks