Help fix macro that is supposed to put a check in a certain column when a row is selected

[lexipants33]

Hi,

I got this code from a YouTube tutorial where if a row is clicked in a specific range, a checkmark will appear in a specific row. It works by putting a character in a column that has wingdings font and that character is a check. When I click in the range it puts the character in the cells in the range and not the specific column I want which is "AI". The code is on the sheet titled "Data Sheet".

What I would like to happen:
The user clicks on any row in the table, then that row is selected and it shows it is selected by displaying a checkmark in column AI at the end of the row. The range starts in row 5 and i want it to be able to go on for any amount of rows. So if 1000 rows are added, the user will be able to select that many rows. Then if the user clicks on the row again, it unselects. They can select multiple rows.

Please help I know the code has to be adjusted I just do not know how! I am a beginner and appreciate this forum so far! Thanks

Lexi

[Arkadi]

Hi Lexi,

Is this more what you are looking for?

Please Login or Register  to view this content.

[Arkadi]

Oh and if you DO want the Target.Offset(0,1).Select line enabled then you'll want to disable events otherwise the code will fire twice and you'll not get the behaviour you expect.

It would be like this:

Please Login or Register  to view this content.

[lexipants33]

Yes! you are wonderful thank you! But... would it be possible to allow the user to click on the same cell to un-select the row? This will be used by people other than my self so I am trying to turn it into something very user friendly.

[Arkadi]

Hi Lexi,

Clicking on the same cell a second time does not constitute a "selection change" and so this event will not fire in that case. There isn't a simple "mouse click event". I will have a look, I may be able to find a way to do this, but the code will certainly be much more complex than the method we are using now.

[Arkadi]

We could use a double-click event if you are willing to make the user double-click to select instead of normal click?

If that is a way to go, then replace the selection change macro with:

Please Login or Register  to view this content.

[LJMetzger]

Arkadi said:

Clicking on the same cell a second time does not constitute a "selection change"

When using code like this, I put the focus on an adjoining cell. That is the purpose of the following line in the original code:

Please Login or Register  to view this content.

Enabling the above line, should eliminate the need for the 'Double Click' Event.

Lewis

[lexipants33]

Hi,

Thank you for your responses. I have tried the double click and it would not work for me. Also I enabled the Target.Offset(0,1).Select line and I recieved an error. But I decided to go for a different approach for simplicity. I want to keep the code how Arkadi had it in the first response. But can you make it so that it only selects the row if they click in column "AG"? I want the user to be able to enter information without the row being selected.

[Arkadi]

How about:

Please Login or Register  to view this content.

[lexipants33]

perfect thank you!