Using Form Combobox in VBA Excel


V

Vipul

Hi,
On my spreadsheet, I have 1 combobox 1 list and 1 button
I have added these controls without any coding, just by using Form Toolbox
(right click on the excel toolbar)
when i click on the button it should add the selected value from combobox to
the list box.

Can i get any help on this please.
Thanking in anticipation.
Vipul
 
Ad

Advertisements

Ad

Advertisements

V

Vipul

hello Kent
thanks for your reply.

i have tried putting the code that you mentioned before, but the problem is
i m getting error message "Object Required"
the code doesnt even show the list of properties and methods when i put a
dot(.) after the name of combobox or listbox.
i m just stuck there.

hope to get your reply again on this.
thanking you again.
b bye.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top