Opening a Userform from a command button

  • Thread starter Thread starter maclachlan
  • Start date Start date
M

maclachlan

I seem to be having problems opening the userform name RepPref
The command button is name Preffrm and is located on a worksheet. Th
Userform is named RepPref, but I get an error when I try to use th
button.

The error is
Run-Time error '424'
Object required


Private Sub Preffrm_Click()
RepPref.Show

I had this working earlier but I'm not sure what has changed to promp
the error.
Thank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enumerate buttons on user form 2
VBA Code== Goto a webpage using a command button in a UserForm 14
macro command button click 1
Activate a moacro subroutine from a userform command button 1
Userform Command Button 3
Centralizing a command button on a userform 8
automation error 0
Command button - compare computer name with a pass code 3

Back
Top