Forum Discussion
Double Click - Choices
Hi everyone
I've got a spreadsheet that is in the form of a checklist.
There is a statement in one column, with three extra columns for the responses, Yes, No, or N/A. I would like it if there is a double click in for instance the Yes column, that it puts a tick (a checkmark) in there and clears the other two columns, and likewise for the others, so there can only ever be one tick across the three columns.
I would appreciate it if anyone has any suggestions on how to do this.
Many thanks
Keith
Keith
See attached - I've added some simple VBA code to add a tick when you double click.
Points to note:
1. If you double click on any cell in columns B-D inclusive the tick will be entered. Double click on any other column and nothing will happen.
2. I have formatted columns B-D as Wingdings to allow the tick to appear
3. If you double click on say column B (Yes) a tick will appear. If you then double click on Column C (No) a tick will appear but the tick in Column B will still be there. I have assume that you understand your process so that you would not do this?
4. I know this is only a test - if you plan to have the columns in other than B-D then the code can be adjusted or the B-D check can be removed altogether - but this will mean that if you double click anywhere on the sheet a tick will be inserted which is not what you want Ii think!
Anyway I hope that helps.
Good luck!
Peter
5 Replies
Keith
See attached - I've added some simple VBA code to add a tick when you double click.
Points to note:
1. If you double click on any cell in columns B-D inclusive the tick will be entered. Double click on any other column and nothing will happen.
2. I have formatted columns B-D as Wingdings to allow the tick to appear
3. If you double click on say column B (Yes) a tick will appear. If you then double click on Column C (No) a tick will appear but the tick in Column B will still be there. I have assume that you understand your process so that you would not do this?
4. I know this is only a test - if you plan to have the columns in other than B-D then the code can be adjusted or the B-D check can be removed altogether - but this will mean that if you double click anywhere on the sheet a tick will be inserted which is not what you want Ii think!
Anyway I hope that helps.
Good luck!
Peter
Are you able to attach your spreadsheet so that we can look at what you are trying to do.
thanks,
Peter
