Trying to get an X to appear in cell when selected

**slimjim1013** · 02-21-2008, 01:01 AM

I am trying to restrict a cell so all that happens when clicked is an X to appear in that cell. I'm new to this so the simpler the better. Thanks!!

**Paul** · 02-21-2008, 01:02 AM

Hi slimjim,

Do you want ANY cell that is clicked to show an X, or just certain cells?

**slimjim1013** · 02-21-2008, 01:09 AM

I guess certain cells, but it is the majority of the worksheet. So far only column A and Row 1 have content in them and I think the rest can be made so that only an X appears when selected(and disappear when selected again). I'm basically trying to make a check list.

**Paul** · 02-21-2008, 01:15 AM

Ok. The following code, pasted into the worksheet's code module, will add or remove an X from a cell when you double-click on it. If you really want just a single-click we could use the Worksheet_SelectionChange event, however that gets triggered every time your cell selection changes (using mouse, arrows, tab, enter, etc.) and you could start adding X's all over the place if you're not careful.

Please Login or Register  to view this content.

This will add or remove an X from any cell when double-clicked as long as it's not in column A or row 1. (B2:IV65536 is fair game).

Update: Added 'Cancel = True' so that the cell is deactivated after double-clicking, leaving just the X or blank (taking you out of cell edit mode).

**slimjim1013** · 02-21-2008, 01:19 AM

When you say code module do you mean Macros?

**Paul** · 02-21-2008, 01:23 AM

Yep.

1. Right-click on the sheet tab for which you want to add this code. e.g. If you want this code to run on 'Sheet1', right-click on that tab then select 'View Code'.

2. In the VB Editor window that appears, paste the code I provided into the right-hand window

3. Close the VB Editor window

4. Double-click any cell in row 2 or below, or column B and to the right.

**slimjim1013** · 02-21-2008, 01:35 AM

Paul,
I appreciate all your help on this, but it doesn't look like its working. It looks like the code is recognized cause it has Blue text(I copied it funky the first time and it was all red) but when I double click a cell it just gives me the option to type in it.

**Paul** · 02-21-2008, 01:40 AM

Can you zip and upload a copy of your workbook to the thread? I can take a look at it for you then.

**slimjim1013** · 02-21-2008, 01:57 AM

Again, thanks for your help. Your Avatar is exactly how I feel btw. =)

**slimjim1013** · 02-21-2008, 01:58 AM

Ok thats wierd I just tried copying and pasting again and now it works....

**slimjim1013** · 02-21-2008, 02:04 AM

Yes!!

It works for sure. I opened a new workbook and created the same checklist and pasted your code. I must have done something wierd on the first workbook when I was searching through all the functions and stuff to try to figure this out. Thanks for putting up with this excel noob!