Excel 10
I am getting this error, method or data member not found on a Userform Text box label. All the other text boxes seem to work fine. I checked the properties and it is spelled correctly. I'm sure it's in my code somewhere. Here is the line of code getting the error:
ElseIf Label_Date.Value = "" Then
Here is my full code:
Please Login or Register to view this content.
Last edited by 6StringJazzer; 08-29-2016 at 03:40 PM.
This error is almost certainly because your UserForm does not have a control called Label_Date. Can you confirm that this control exists? If so, can you attach your file so we can investigate further?
Ok, thanks Jeff. I will take a look at the UserForm. Also, I don't want to attach the file incorrectly. Can you send quick instructions on how, Thanks.
Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Ok, I figured out my error on the text box label issue, but now I'm having an issue with the 2nd combo box. First combo Box works fine, but no drop down list is showing up on the 2nd combo box. I am attaching the sheet. You can go through a dummy trial of adding a complaint and see how it happens.
Here is the code:
Please Login or Register to view this content.
Last edited by 6StringJazzer; 08-30-2016 at 08:43 AM. Reason: Adding missing bracket to fix code tag
You have UserForm_Initialize declared twice so the form doesn't come up at all. I think your problem will be solved if you combine the code from those two subs into a single sub.
It's also confusing that you have a field labelled "Complaint Type" but the corresponding combobox is called ComboBox_Country1. That doesn't cause a bug but it makes the code very confusing.
Thanks for all you have done. I figured it out. Can't have both declared twice. I put the code under one and it works perfectly.
Again, thank you very much!!
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
If posting code please use code tags, see here.
kwesmc1, MrExcel has the same rule. Please update both forum threads to show the cross-post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks