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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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