Hi,
Can anyone help with my conundrum? Ive asked my code to populate Combobox15 with "CORDA006" when Combobox has a value of/between 370 and 400
and when combobox5 is populated with 75. It runs with no errors but doesn't seem to do anything?
Please Login or Register to view this content.
How do you know this part of the code is actually running? There is code before this part and it may be exiting the procedure or doing something that prevents this part from executing.
On another note: Application.EnableEvents has no effect on UserForm controls.
Suppressing Events In UserForms
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
its under the user form initialise instruction. I should delete Application. Enable Events? Ill check the code and get back
No change. Here's the code for the userform, its quite extensive but is mostly the contents of comboboxes. The code I am confused about is at the end
Please Login or Register to view this content.
This should do it.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Probably won't...
ComboBox1 will have its ListIndex = -1 at this stage so the value will be 0. The code really should be in the Change event for a Combobox, not too sure if it should be CB1 or CB5, or possibly both.
Looking at your initialization code, you populate the combobox lists, but don't set any values for them. So it would seem they have no values when you open the userform, and the IF statement would never be true.
EDIT: do what cytop said and put the IF in both Combobox1 and Combobox5 _Chnage procedures
Please Login or Register to view this content.
Last edited by AlphaFrog; 09-27-2016 at 07:51 AM.
Hi bakerman, I've just updated using your code and got this?
Hi Aplhafrog, is this correct?? it doesn't seem to do anything@
Last edited by bralew; 09-27-2016 at 08:06 AM.
Might I suggest that you post the actual file itself, please?
Don
Please remember to mark your thread 'Solved' when appropriate.
yeah no worries, ill put it up now.
None of the values in combobox1 are between 370 and 400.
I think I have mentioned before that you really should consider loading your controls from ranges to make maintenance easier. Even if you do need to hardcode them, you can make the code more efficient by using arrays
Please Login or Register to view this content.
I'll do that in future, that looks much better, thanks ever so much. It works fine, I've enough work to keep me busy now Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks