Hi Guys,
I am currently running VBA when ComboBox1 is selected ComboBox2 shows specific information based on lists in the spreadsheet.
Now I would like it if ComboBox2 showed "Business Improvement" then ComboBox3 will show information set in that list.
Also, my submit button isn't working and I can't find out what's wrong using the debugger
I've attached the spreadsheet as the lists will make more sense and hopefully you can help me.
Thanks in advance.
Frank
Hi there,
the issue is in 'ComboBox2_Change'.
You pick a text 'Business Improvement' and You test it against 'Business_Improvement' with underscore.
Should be:
Is this Your issue?
Please Login or Register to view this content.
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
I was missing one s on 'Business' haha, thanks for pointing it out..
The problem I have now is when I press the submit button I get 'Compile Error' 'Block If without End If'
How can this be fixed, thanks.
Can You post the code with changes You made (& compile err)?
Of course, no problem..
The error I get is 'Compile Error: Block If without End If'Please Login or Register to view this content.
If you can help i'd appreciate that!!
Thanks
Hi there,
look at this part:
You have there 3x 'If' but only 1x 'End If'.Please Login or Register to view this content.
You should put 'End If' also after the first two 'Exit Sub' statement.
Also You are using While-Wend to get the first blank cell (row) by looping through all rows.
Isnīt it better to use any variationt of:
?Please Login or Register to view this content.
Yes, that was it!!
It's sorted now....
Thanks soooo much dude
You are welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks