Userform error in custom ribbon

**taralmehta15** · 01-29-2016, 02:43 AM

Hi friends,

I created a custom ribbon (working with excel 2007) And want to open a userform on clickin the button in the ribbon but Everytime I do that, I get

Run-time error '424':

Object required

Is there a way to solve this? The userform is in the new file vich opens and not in the ribbon (Is that why this error occurs? Coz I would prefer the userform on the file only instead of ribbon) . Here is the code i want to work (it works ok with command button inserted on file but doesnt work with ribbon):

Please Login or Register  to view this content.

I have a way out but its not so good. (I used inputbox in ribbon button for all the fields vich I want in userform but it doesnt luk quite gud).

Kindly guide me regardin this error.

Thanx a lot.....

**BadlySpelledBuoy** · 01-29-2016, 03:56 AM

I suspect that "UserForm1.Show" is NOT the actual line that is causing issues.
You'll need to step through the code line by line (tap F8 when the UserForm.Show line is highlighted during debug) and see which line it eventually errors out at.

Post that code and highlight the issue row. Or better still, post your workbook.

BSB

**taralmehta15** · 01-29-2016, 05:39 AM

No that's d only code in action

When I run the code, The target workbook opens i.e. the 1st line of code works ok. The 2nd line of code has to show userform1 but that part I get error with UserForm1.Show highlighted in yellow. The entire code works fine if i press command button on the file but gives error when I use it in ribbon.

Attaching both the sample files here (xlam ribbon format not supported so i am posting it as xlsm. Kindly save it to xlam to use it as ribbon. Also xltm doesnt upload so I have changed the target file format to xlsm)