View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Combobox List - Which Property

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