Hello
Is it possible to have a x when the checkbox is on and not a "v"


I use Excel 2003

thanks

It's a checkmark not a vee. The right part is longer than the left.

And, no, I don't think it can be changed back to a 'x'.

Personally, I've never been happy with 'x' since I can never be sure if
the person means 'x' as in select this or 'x' as in discard this and
select the other one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello
Is it possible to have a x when the checkbox is on and not a "v"


I use Excel 2003

thanks

A solution that may be acceptable is to set it up so that the worksheet cells
act like check boxes using the Selection_Change event except that it toggles
an "X" instead of a checkmark (You can rig it to toggle checkmarks also).
Alternatively, place transparent rectangles over the cells and assign a macro
to each that toggles the text of the underlying cell. You need only one macro
to handle this irrespective of the number of rectangles.

The former technique is especially useful when you will be doing a log of
editing since there is essentially no maintenance required if you increase of
decrease the size of the list. I actually prefer either of the above over
using check boxes because of the superior text capability of worksheet cells
as well as there being no size restriction.

Regards,
Greg



"starfighter61" wrote:

Hello
Is it possible to have a x when the checkbox is on and not a "v"


I use Excel 2003

thanks

That's a slick idea!

"Greg Wilson" wrote:

A solution that may be acceptable is to set it up so that the worksheet cells
act like check boxes using the Selection_Change event except that it toggles
an "X" instead of a checkmark (You can rig it to toggle checkmarks also).
Alternatively, place transparent rectangles over the cells and assign a macro
to each that toggles the text of the underlying cell. You need only one macro
to handle this irrespective of the number of rectangles.

The former technique is especially useful when you will be doing a log of
editing since there is essentially no maintenance required if you increase of
decrease the size of the list. I actually prefer either of the above over
using check boxes because of the superior text capability of worksheet cells
as well as there being no size restriction.

Regards,
Greg



"starfighter61" wrote:

Hello
Is it possible to have a x when the checkbox is on and not a "v"


I use Excel 2003

thanks