User Form

[redstang423]

Hi all,

Jason helped me a little while ago to set up user forms. I have all the code written for it (I assume correctly). I can't figure out how to actually start up this form though. The form is called "frmSpecs". I am trying to start it through a command button (I've even tried assigning a macro through a clip art picture) using the following code:

Please Login or Register  to view this content.

Even if I remove the "Load" line, I still get a run time error 424 saying "object required." What am I doing wrong???

Thanks for your help,

Jeff

EDIT: The tutorial I used is http://www.exceltip.com/st/Create_Us...Excel/629.html

[jasoncw]

Hi again, Jeff. When the run time error shows, can you debug? If so, what line is highlighted?

Jason

[redstang423]

the Load line is highlighted when I click debug. If I delete this line, the frmSpecs.show line is highlighted, with no change of the error message. The name of the actual form (as it shows in the project explorer) is "frmSpecs" if that makes any difference. I've looked at other tutorials and searched google a bit with no success. Is it possible the computers I am using are missing an add in?

[jasoncw]

No, that shouldn't be the issue. Is it possible to upload a zipped copy of your workbook so I (or someone else) can check it out?

[redstang423]

I attached the spreadsheet. It will likely be something silly that I left out somewhere and just never found when I triple checked everything. Thanks for your help.

[Dean England]

Redstang,

The first thing I notice, until someone more knowledgeable comes along, is you have not named your textboxes and comboboxes properly in the properties window. If your text box is ProductName in the properties box it should be written as txtProductName, txtBottles, txtBottlesize, cboProduct, etc. Otherwise, excel can't find it-Hence your error.

Dean

[redstang423]

Dean, I'm not sure I am following exactly what you are saying. I have named the text box itself ProductName in the properties window, and referred to it as txtProductName in the code itself. The labels I left named as Label1, 2, 3, etc. Do I need to change label names as well, or did I just completely misunderstand what you were trying to tell me?

Thanks,
Jeff

To try to help clarify my issue here, in Debug mode, if you hover over frmSpecs, it says " frmSpecs = <Object variable or with block variable not set> "

[Dean England]

Redstang,

When you labeled the textboxes and comboboxes in the Properties Window you did not include the "txt" preceeding the textbox names or the "cbo" preceeding the combobox names. Therefore, the boxes on the Userform have not been defined, properly. Sorry, I gotta run. Hopefully, this will be a little help and someone with more knowledge than I will be along to help you more.

Dean

[jasoncw]

Hi, Jeff. Your problem is referencing to the objects in the user form. You need to reference it in the procedures just as you named it. So if you named the actual text box 'ProductName', you cannot refer to it in the procedures as 'txtProductName'. I would just rename your objects within the user form to agree with your coding.

... Looks like Dean beat me to it.

HTH

Jason

[peejay]

I took a look at your code, it is always important to referance the userform objects in the code exactly as they are named in the properties window.

removing the txt and cb referances from the start of the names works fine for me,

looks like i got beaten to it too................

[redstang423]

Dean, Jason, and PeeJay: Thank you for your help! That was the issue. I must've misinterpreted how the tutorial was telling me to code everything compared to naming it. Thanks again!

Jeff