-
Attach event to multiple ComboBoxes
Hi, I have a multipage with total of 50 comboboxes.
When Userform loads, they start with same items sourced from Range("A1:A50")
As I start to select values box by box, I'd like to have number of options in next ComboBox shrink by 1.
So I'd like to attach one change event to all 50 combos instead of 50 subroutines.
I found similar thread:
http://www.vbaexpress.com/forum/show...during+runtime
However, it's beyond my comprehension.
Can anybody help please?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules