VBA to expand a referenced range of cells

Hi all,

Looking for some help with my code.

Here is what I have:

A combobox that references a range of cells and that launches another UserForm when "Other" is selected:

Please Login or Register  to view this content.

And a UserForm that adds another value to the combobox:

Please Login or Register  to view this content.

What I would like to happen is the following: When a value is added using the AddOtherValue UserForm it adds to the worksheet where the combobox is making the referenece (in addition to the combobox code that exists already). I would then like the range being referenced by cmboProjectType to expand by 1 (so that the next time this UserForm is launched it will show the new value that was added in the dropdown)

The easiest way I see to accomplish this is to have the range reference a value (say A3) and to keep referencing values in that column until it reaches a blank.

I am open to suggestions though!

Thanks in advance,

Wolf

I would normally file a combobox in the Userform's Initialize event.

This should give you an idea.

Please Login or Register  to view this content.

Brilliant this is exactly what I needed! Now one other issue: I want to have the value "Other" at the bottom of the dropdown list. Could I add it like this?:

Please Login or Register  to view this content.

Well clearly this code is wrong but you get the idea! Just want the value Other to always be at the bottom of the dropdown list...

Please Login or Register  to view this content.

Only thing I don't like about the .AddItem is that if you hit the dropdown a second time it adds the value again... But yeah this works. Thanks for the help!

I would not fill it that way myself. Try using .clear to clear the entries?

I guess one might also want to consider removing duplicates from such a list. IF you want that, reference this thread and ask for it in another thread.

Originally Posted by Kenneth Hobson

I would not fill it that way myself. Try using .clear to clear the entries?

I guess one might also want to consider removing duplicates from such a list. IF you want that, reference this thread and ask for it in another thread.

I think you mean...

IF you want that THEN reference this thread haha

End If

Just trolling.

Thanks again for the help!