Object required error on CommandButton Click

**rkjudy** · 01-09-2011, 03:16 PM

I have a CommanButton on a sheet that simply opens a UserForm, but I get a Run-time error 424.....Object required error. Can anyone tell me how to fix. I'm new to VBA. See code:

Private Sub CommandButton1_Click()
    frmOrderEntryInfo.Show
End Sub

**jeffreybrown** · 01-09-2011, 03:25 PM

Nothing looks wrong there. Are you sure the name is correct?

**rkjudy** · 01-09-2011, 03:39 PM

I don't understand. The form name is correct. Could if be something to do with the properties of the form or the command button? Is there a missing object or something missing in Tools>References? This did work before. I did install the Analysis Toolpack add-in. It slowed down my workbook so much, I uninstalled it. Could this have done something?

**jeffreybrown** · 01-09-2011, 03:43 PM

Is it possible to attach the workbook?

**rkjudy** · 01-09-2011, 04:02 PM

It's probably something simple. Here's the workbook. Thanks, in advance for your help.

**jeffreybrown** · 01-09-2011, 04:29 PM

Hello rkjudy,

Well I sure can't see any reason for this not to work. Hopefullly one of the other members or a Forum moderator will help.

On an aside and still being a rookie, it seems you could just use a regular forms button for a click type procedure versus the active x. Not entirely sure the difference. Guess I need to do some reading.

Also, the slowness could be from the way you have your code. It appears you must have used the macro recorder to get most of your code. There is no need to use all of the Select/Selection.

If you don't mind I will clean some of it up and send you a sample. In the meantime hopefully somebody will come to our rescue.