I have created a user form that has a row of ComboBoxes I need filled with a bunch of sites. I had this set up to list in each ComboBox, but the code was getting way too long so I decided to try and declare the array and list it in the ComboBoxes that way. However, I am getting the above error and cannot figure out if I missed a step or have something written wrong. Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by Billroz; 03-02-2016 at 08:20 PM. Reason: Added Code Tags
You are missing a double quote afterPlease Login or Register to view this content.
Please add Code Tags to your code excerpt
Hello Billroz,
Welcome to the Forum!
Check the names of your ComboBoxes. I created a UserForm with 2 ComboBoxes and the code below worked for me.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Check the object names for ComboBox3 and SiteComboBox1.Run-time error '424': Object required
If you add Me keyword, you can avoid mistake.
e.g
Please Login or Register to view this content.
Sorry, this happened when I tried to simplify to make it easier to read. Below is the original Code. I hope I did the code tags correctly...
Please Login or Register to view this content.
Thank you, Leith, and everyone else.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks