Kasggarinn,

Control toolbox combobox or data validation lists? I think the choice would
be dependent upon what you want to do with the final selection, if you just
want to see the value, DV is good enough. If you want to run a macro
dependent upon the planetary system chosen, the control toolbox version
would probably be better.

--

HTH

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

"Kashgarinn " wrote in message
...
Bob:

Thanks alot for your reply. Your solution sounds interesting, and I'd
love to take a gander at it.

I'm using excelforum.com to check this out, and it didn't display an
e-mail I can reply to.

Please e-mail your solution to

Thanks alot for your help.

Trev:

Thanks alot for your reply. I'll check the on_update function, thank
you.

I don't really want to use access as I wouldn't first know how to
implement it into excel, and I would like to be able to share my file
to others without them needing anything more than an excel viewer, or
excel.

It should be rightfully called a planetary star system.

K.


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