The Rowsource is a string property and you were setting it to a range. This
part, Sheet1!B50:B56" , is a nice simple string, when using a reference to
another part of a worksheet it is not so obvious is it.

Anyway, glad you are sorted now.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CAA " wrote in message
...
Sorry Bob
However a guru like yourself can spot these problems without
explanation ;-)

The problem was it didn't populate my combobox.
I tried your piece of code and still nothing, so I trimmed out the
first bit and then realised that an erlier attempt only needed the
Address at the end. Which after trimming yours was exactly what I
needed.

I need to read more about the references cells, previously I had gotten
away with just "Sheet1!B50:B56" but had never ttried within an if
statement to set it at runtime, quirky stuff.

Thanks alot for your help, my day has just become lighter.
CAA


---
Message posted from http://www.ExcelForum.com/