Hi, I have two comboboxes, I am able to update the second combobox dependent on the value of the first with the code below. But if I use the same code for the second combobox the userform crashes. Any ideas on how I could get the first to update the second and vice versa?
Please Login or Register to view this content.
Edit: The above code is wrong I just realised, I will keep working on it but if anyone has any input I'd be grateful.
Last edited by fionamb83; 05-17-2013 at 07:29 AM. Reason: Mistake in code
What you want to do is set up a global flag (a boolean variable) so that when
you are making a change to one of the 2 combo boxes, the global flag will cause
the combo's change event code to execute fully only once during the current operation.
In a new modle insert
Here is the form code I tested. It has 2 combos and a command button: ComboBox1, ComboBox2, cmdDonePlease Login or Register to view this content.
Please Login or Register to view this content.
This is a massive help thank you. I don't think I would have thought of this at all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks