Click and Mark a cell with an "x"

[dgaller]

Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?

[shg]

Right-click the Quote Main tab, select View code, and paste this in the window that opens:

Please Login or Register  to view this content.

Double-click in K43:K49 to toggle between x and blank.

[dgaller]

Thank you.

[shg]

You're welcome. Please mark as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[dgaller]

How do I expand this to include other Cells? i.e cells I43:I49

[shg]

Please Login or Register  to view this content.

[dgaller]

When I past this in I get a debug error on the If LCase(.Value) = "x" Then line

[shg]

Post the workbook.

Edit: A compile error or a run-time error?

[dgaller]

run-time error '13', Type Mismatch.

[shg]

What's in the cell when you double-click it?

[dgaller]

Blank. I just noticed its a merged cell does that matter?

[shg]

It matters. Don't merge cells.

[Nick T]

Hi,
I have added the code you gave for use on my sheet across multiple cells and this works great on my laptop, only I want to use this on my Galaxy note tablet and I am having some issues.
Is there a way of making it so a "single" click would bring the "x" in instead of two, as when I use my tablet and click twice it brigs the keyboard up therefore not allowing me to click twice.

Thanks.

[ELLIS106]

Right-click the Quote Main tab, select View code, and paste this in the window that opens:

Please Login or Register  to view this content.

Double-click in K43:K49 to toggle between x and blank.

ok, I copied that into the "View Code" page on my sheet, but do I then save that to my file name?

[ELLIS106]

Rather than use an "X" or other alpha numeric symbol, is there a way to change the color of the cell when clicked on?

[ELLIS106]

Also, now when I go to save my spreadsheet, I get the following message. How do I save the file to include the cell feature?

[shg]

As the messgae says, you need to save it as an xlsm file. By design, Xlsx files do not, can not, contain macros.

[ELLIS106]

As the messgae says, you need to save it as an xlsm file. By design, Xlsx files do not, can not, contain macros.

Got it, forgot that you have to do that manually, which I don't understand why. Thanks

[shg]

It would be very bad behavior if Excel did it automatically.

You're welcome.