Hi Denys,

Am Wed, 15 Apr 2015 09:53:58 -0700 (PDT) schrieb
:

Private Sub CheckBox1_Click()
If CheckBox1 = True Then Combobox8.Rowsource= "Projects"
end sub

why do you need a combobox in which all entries are "Projects"?
In range("Projects") every cell has the value "Projects"


Regards
Claus B.

Probably needs to be more like...

If CheckBox1 = True Then Combobox8.List = Split(strData, ",")

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion