I have a homework assignment and I was checking my progress to make sure I was going along alright and I keep getting this error. And it highlights the Sub Workbook_open() part of VB. I would appreciate any help I can get. Thank you.
I have a homework assignment and I was checking my progress to make sure I was going along alright and I keep getting this error. And it highlights the Sub Workbook_open() part of VB. I would appreciate any help I can get. Thank you.
Last edited by jaje21; 10-25-2011 at 02:25 PM.
Firstly you have code in thisworkbook object that is placed outside of any routine. I think the code should be in the workbook open event.
The error you highlight is cause by using the same name for a control on the userform and a const declared within the scope of the userform object.
Either change the names or move the consts into a standard code module and declare as public consts.
Hi jaje21
Welocome to the forum
You have a constant and Optionbox both named "regular_shipping". you will have to change one to a different name
Thank you Pike for the welcome. Thank you both for the help. We took the workbook from an earlier assignment and were to make it more involved so that is where this is come from so again thank you. I am sure I will be posting a lot more because this is an online class and I'm not very confident in doing VB.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks