And a lot harder to read from the dropdown especially if you have a 75% zoom


--
Regards,

Peo Sjoblom


"Dave Peterson" wrote in message
...
If you think that a combobox would be easier, you may find that
Data|Validation
is even easier. It looks kind of the same and behaves kind of the same,
but is
lots easier to implement (and lots easier to break!).

Debra Dalgleish has lots of tips:
http://contextures.com/xlDataVal01.html

Vick wrote:

I was looking at it and a combo box might be easier, but I have no idea
how
it works. How do I get my values in the drop down box? Also, can I have a
macro run for each of the selections in the drop down box? I'm open to
new
ideas, whatever is easiest is fine with me.

Thanks Again

"Vick" wrote:

Ok, I'm using the Control check boxes. I have 6 of them. On each of
the 6 I
have assigned a Macro to do something on the page. I have 2 problems.

1)I want to make so that only one box can be selected (Not sure if
there is
a way to do that or have a macro to clear the rest of the check boxes)

2) I want two different actions when the box is unchecked. Right now
the
macro runs when I check or uncheck the box. I would like one macro to
run
when I check the box and one to run when I uncheck the box. Is there a
way to
accomplish this?

Thanks

--

Dave Peterson