VBA Code for Entering Data With Double Clicks

[Al0387]

Hello All:

I am trying to build a Survey Form in Excel where I want to simplify the data entry by allowing the user to enter data by double-clicking on cells (or buttons), with some areas for text input.

Some questions will have multiple answer options by I want to force only one selection from the available options (e.g. Strongly Agree, Agree, Unsure, Disagree, Strongly Disagree).

Could some one please recommend some starter VBA code? I am building my VBA knowledge, so any simplistic starter code would be very helpful.

Many Thanks
al0387

 

[Logit]

.
http://www.contextures.com/xlForm01.html