Double Click Button

Here is another option fo ryou. If you want the cell you are double-clicking to say "Correct!" by double-clicking on it, try this:

- right-click on the sheet tab and select view code
- copy the following code to the VBA window:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Target = "Correct!"
End Sub

HTH,
Jason

Thanks for both suggestions. The Active X route is the way I think I'll go. I want the button to remain saying 'Double Click Here!' while the cell immediately to the right displays correct or maybe a smiley.

I didn't try Active X before. I had encountered that code in the help file but didn't connect it to Active X. I knew there had to be a more 'native' way to do it. I should be good now. I'll report back with results.

Thanks again! The Active X button worked out great! I haven't used the Control Toolbox Toolbar at all yet. It was a good little adventure. Once I figured out how to toggle design mode, it was super easy as promised.

I teach in a computer lab that pulls students from various Adult Education classes (ESL and GED). This little button will be part of a self-grading mousing and typing test that will condense two separate documents used each twice a semester each 12 weeks with 150-200 students. Each year that's 4 x 2 x 175 tests I don't need to grade or print out hard copies for. This will save me hours and hours of work. The bonus for studens is instant feedback about the correctness of their actions. They will KNOW when they have it right. This makes them much more determined and dramatically improves their engagement and retention. Your little help goes a long way.

One more super thanks!