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

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