Not a problem. But it is a pretty easy thing to try--even if it fails.

exceltim wrote:

Dave Peterson Wrote:
I didn't suggest using a listbox. I suggested changing the style from a
combobox--where you can choose from the list or type something new to a
combobox
where you can only type what's in the list (or choose from that list).

I'm very sorry Dave.... I was not long out of bed when I read your post
(was early morning here in Australia) and I must have still been half
asleep! I can see what you're saying now.

I had a little play with it, and it looks like a great idea.... I'll do
some more testing with the spreadsheet before deciding on which option
to use.

Sorry again for the misunderstanding, and thanks very much for your
help!

Tim

--
exceltim
------------------------------------------------------------------------
exceltim's Profile: http://www.excelforum.com/member.php...o&userid=30464
View this thread: http://www.excelforum.com/showthread...hreadid=501310

--

Dave Peterson