I have a multi column combo box that i want to set a default value for, but
can't seem to figure it out. It currently is blank by default. I know with
a single column combo box you can use the .Value property but this doesn't
seem to work with a multi column combo box. Any thoughts?

use
..TEXT=
OR
ComboBox1.Listindex = 4 ' if you know the 0-based item number

"babcock" wrote in message
...
I have a multi column combo box that i want to set a default value for,
but
can't seem to figure it out. It currently is blank by default. I know
with
a single column combo box you can use the .Value property but this doesn't
seem to work with a multi column combo box. Any thoughts?

This should shed some light on the subject of how ComboBoxes work:
http://www.contextures.com/xlUserForm02.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Patrick Molloy" wrote:

use
..TEXT=
OR
ComboBox1.Listindex = 4 ' if you know the 0-based item number

"babcock" wrote in message
...
I have a multi column combo box that i want to set a default value for,
but
can't seem to figure it out. It currently is blank by default. I know
with
a single column combo box you can use the .Value property but this doesn't
seem to work with a multi column combo box. Any thoughts?