Forum Discussion
Double Click - Choices
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
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
Peter
Thank you very much for this.
I am sure that I will be able to use this.
Many thanks
Keith
