How to add values to combo box

[Arpanakumar]

Hello

Wanted to add some values to combo box programatically...Please help.

 

[Monty]

Hi

Try this..

As there is no sample attatched!

With ComboBox1
  .AddItem "Excel 2003"
  .AddItem "Excel 2007"
  .AddItem "Excel 2010"
  .AddItem "Excel 2013"
  .AddItem "Excel 2016"

End With

 

[Arpanakumar]

Cool!.

But wanted this to be ready when i open my excel.

 

[Monty]

Hello

If you know events...problem is solved.

Check the below screenshot use the above code in the workbook open event that meens when ever you open workbook your combox is loaded with the items.

Let me know any challenges!

 

[Arpanakumar]

Monty!
Oh that's great..need to understand events as refered as of now adding everything to buttons..Quite intresting..thanks

 

[Monty]

Refer for more info.
http://www.excel-easy.com/vba/events.html

 

[Arpanakumar]

Hello Monty.

Quick question on combo box..
How to avoid some one to enter manually in combo box please.

 

[Monty]

Try this
It's a property setting for combobox.

Change the Style to dropdownlist.

 

[Monty]

Arpana.

Change the dropdown for Style property and check 1 allows you to enter data in combobox and 2 restricts..Hope this helps.

The best way of learning about controls by going to each property and testing it..

 

[Arpanakumar]

Noted by your Fannnnnnnnnnnn!

 

[Monty]

Thanks a Million!..Happy learning!