open userform

[kosherboy]

Hello.
I'm a little stuck, I'm trying to prepare a chart for my office that should open a user-form when "Open Order Form" is selected from the drop-down menu which is located under column S but i keep getting a "Run-time error '424: Object required" message, and when i "debug" i get directed to "Userform1.show". I am not sure what the problem or where the problem is located.
Here is my workbook uploaded OFFERS 2015.xlsm
*I posted this problem earlier today but ran into some trouble because i accidentally posted a password protected workbook and had trouble uploading a new file.

[JieJenn]

For some of the objects, you need to declare your variable. For example

Please Login or Register  to view this content.

[kosherboy]

Hi.
If you go into the sheets code you will see the following variables being publicly declared:

Please Login or Register  to view this content.

[nilem]

Hi kosherboy
there are

Please Login or Register  to view this content.

but there are no CustBox11, CustBox12, PriceBox11, PriceBox12 on your form

also
it would be better if you declare global variables in a standard module (not in the sheet module)

[kosherboy]

You are a genius!
Hats off to you!
Thank you so much

[kosherboy]

Any reason why the debugger didn't identify the problem right away?

[kosherboy]

Hi kosherboy
there are
.......
it would be better if you declare global variables in a standard module (not in the sheet module)

Hi nilem,
I'm marking this thread solved.
if you can guide me as how i could set up the debugger to identify the problem directly, like any other vb project i have, that would be great.

Thanks

kosherboy.

[nilem]

Hi kosherboy,
considering your project, I just set a breakpoint (F9 can be used) on the first executable line of the UserForm_Initialize procedure. And then, step by step (using F8) went through the procedure and found the line where the error occurs.
That's all
If you have a macro that calls another macro, you can catch errors in 'another' macro using this method.

[kosherboy]

Ok, thanks for the tip