Combobox List - Which Property

A simple question - how does one populate a combobox with a list of values:
Client,Value, Revenue

And then I will use:

Private Sub ComboBox1_Click()
If ComboBox1.Value = "Client" Then
Call Client
End If
End Sub

To call functions

Thanks

Hi

one way is to code on the userform_initialize event

ComboBox1.additem "Client"
ComboBox1.additem "Value"
ComboBox1.additem "Revenue"

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"teresa" <teresa@discussions.microsoft.com> wrote in message
news:6784E5BE-BEDF-4D7E-A720-C61C40590781@microsoft.com...
>A simple question - how does one populate a combobox with a list of values:
> Client,Value, Revenue
>
> And then I will use:
>
> Private Sub ComboBox1_Click()
> If ComboBox1.Value = "Client" Then
> Call Client
> End If
> End Sub
>
> To call functions
>
> Thanks

Julie,

Forgive my ignorance - userform_initialize event?
where do I actually code this.

T


"JulieD" wrote:

> Hi
>
> one way is to code on the userform_initialize event
>
> ComboBox1.additem "Client"
> ComboBox1.additem "Value"
> ComboBox1.additem "Revenue"
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "teresa" <teresa@discussions.microsoft.com> wrote in message
> news:6784E5BE-BEDF-4D7E-A720-C61C40590781@microsoft.com...
> >A simple question - how does one populate a combobox with a list of values:
> > Client,Value, Revenue
> >
> > And then I will use:
> >
> > Private Sub ComboBox1_Click()
> > If ComboBox1.Value = "Client" Then
> > Call Client
> > End If
> > End Sub
> >
> > To call functions
> >
> > Thanks
>
>
>

Hi Teresa

it has just occured to me that you might not be using a combo box on a
userform but directly in a worksheet ... if this is the case then if you
created the combo box using the control toolbox toolbar then the property is
LISTFILLRANGE where your three items are typed somewhere in three cells.

if you are using a userform to present the combobox, then double click on
the userform will get you into the userform code and then from the top right
drop down box, choose initialize and put the code in there
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"teresa" <teresa@discussions.microsoft.com> wrote in message
news:1DD206F2-7349-4227-A01A-6D2A6BBD2196@microsoft.com...
> Julie,
>
> Forgive my ignorance - userform_initialize event?
> where do I actually code this.
>
> T
>
>
> "JulieD" wrote:
>
>> Hi
>>
>> one way is to code on the userform_initialize event
>>
>> ComboBox1.additem "Client"
>> ComboBox1.additem "Value"
>> ComboBox1.additem "Revenue"
>>
>> --
>> Cheers
>> JulieD
>> check out www.hcts.net.au/tipsandtricks.htm
>> ....well i'm working on it anyway
>> "teresa" <teresa@discussions.microsoft.com> wrote in message
>> news:6784E5BE-BEDF-4D7E-A720-C61C40590781@microsoft.com...
>> >A simple question - how does one populate a combobox with a list of
>> >values:
>> > Client,Value, Revenue
>> >
>> > And then I will use:
>> >
>> > Private Sub ComboBox1_Click()
>> > If ComboBox1.Value = "Client" Then
>> > Call Client
>> > End If
>> > End Sub
>> >
>> > To call functions
>> >
>> > Thanks
>>
>>
>>

Julie - you're right,I was using this in a worksheet- so its the LISTFILLRANGE
property that I have to use

Thanks A Million

"JulieD" wrote:

> Hi Teresa
>
> it has just occured to me that you might not be using a combo box on a
> userform but directly in a worksheet ... if this is the case then if you
> created the combo box using the control toolbox toolbar then the property is
> LISTFILLRANGE where your three items are typed somewhere in three cells.
>
> if you are using a userform to present the combobox, then double click on
> the userform will get you into the userform code and then from the top right
> drop down box, choose initialize and put the code in there
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "teresa" <teresa@discussions.microsoft.com> wrote in message
> news:1DD206F2-7349-4227-A01A-6D2A6BBD2196@microsoft.com...
> > Julie,
> >
> > Forgive my ignorance - userform_initialize event?
> > where do I actually code this.
> >
> > T
> >
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> one way is to code on the userform_initialize event
> >>
> >> ComboBox1.additem "Client"
> >> ComboBox1.additem "Value"
> >> ComboBox1.additem "Revenue"
> >>
> >> --
> >> Cheers
> >> JulieD
> >> check out www.hcts.net.au/tipsandtricks.htm
> >> ....well i'm working on it anyway
> >> "teresa" <teresa@discussions.microsoft.com> wrote in message
> >> news:6784E5BE-BEDF-4D7E-A720-C61C40590781@microsoft.com...
> >> >A simple question - how does one populate a combobox with a list of
> >> >values:
> >> > Client,Value, Revenue
> >> >
> >> > And then I will use:
> >> >
> >> > Private Sub ComboBox1_Click()
> >> > If ComboBox1.Value = "Client" Then
> >> > Call Client
> >> > End If
> >> > End Sub
> >> >
> >> > To call functions
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>