Add items to a combo box

[funkmonsteruk]

Hi, using my first combobox in excell and having a few problems.

I want the combobox to list e-mail addresses (either by the name of the person or their full address) and i need the user to be able to select a value from the combo box.

I need to be able to do two things: Firstly how do i add items to the combobox in the firat place (basic i know but this is my first attempt with a combo box)

Secondly how do i reference the selected e-mail address for my vba routine i'm guessing it'll be along the lines of ComboBox1.Value, but couldn't be sure....

If anyone con help would be grately appreciated

Funkmonsteruk

 

[xlbo]

For 1:
ComboName.clear
For Each c in range("A1:A25&quot
comboname.Add(c)
next

This is dependant on you having a list to iterate thru. If the list will never change, then just set the SOURCEdata to your list.

To reference the selection in the combobox, use
ComboName.Text

This is based on teh combobox being on a form - the syntax for a worksheet based combobox is slightly different





Rgds
~Geoff~

 

[funkmonsteruk]

Hi,

It's actually on a worksheet, how would this affect the code...

Funkmonster

 

[xlbo]

You need to use Sheets("Sheetname&quot.shapes("ComboboxName&quot.
etc etc Rgds
~Geoff~