VBA Code for Entering Data With Double Clicks

Al0387

New Member
Joined
Dec 27, 2017
Messages
3
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
 

Forum statistics

Threads
1,085,724
Messages
5,385,509
Members
401,957
Latest member
Socksnpants

Some videos you may like

This Week's Hot Topics

Top