It didn't work. I keep getting a run-time error code, "1004": Application
defined error.

"JRForm" wrote:

Doug,

Place this behind the command button on the sheet

Private Sub CommandButton1_Click()
Load UserForm1
End Sub

"Doug" wrote:

I can load it from a module or from a forms routine, but not from a worksheet
routine. I want to be able to have it load when a command button (residing
on the worksheet) is clicked.