Add same list in multiple comboboxes

**aman1234** · 06-07-2011, 03:43 AM

Hi guys
I have written the following code but its giving me runtime error "Object required".

ANy help would be much appreciated.

Please Login or Register  to view this content.

**snb** · 06-07-2011, 03:51 AM

Do not use 'additem' to populate a combobox/listbox, but use 'List' instead.

Please Login or Register  to view this content.

**mohd9876** · 06-07-2011, 03:52 AM

remove the parantheses

Please Login or Register  to view this content.

**pike** · 06-07-2011, 04:00 AM

it doesnt know which object/userform

Please Login or Register  to view this content.

**royUK** · 06-07-2011, 04:07 AM

Try this

Please Login or Register  to view this content.

**aman1234** · 06-07-2011, 04:27 AM

Thanks guys for your help. All methods worked well. This is the first time I used split and array function and it works a treat.

**pike** · 06-07-2011, 04:41 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save