In Excel, how do I create a point and click icon?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a multiple choice test in Excel (2002) format and I
would like to create an icon of a box, that when clicked on, will insert a
check in the box (a macro would be running in the background that would keep
a running tally of correct scores). How can I do this?
 
Hi
what about using the already existing checkboxes controls?
1- Checkbox from the Forms toolbar
- display the toolbar by going in menu View > Tooolbars > Forms
- click a checkbox and put it on the sheet
2- Checkbox from the Control Toolbox toolbar (ActiveX)
- display the toolbar by going to menu View > Toolbars > Control Toolbox
- click and put on the sheet
 
Thank you, Sebastienm. That helped . . . but is there a way of customizing
the checkbox? (ie: increasing the size of it, and possibly making it a
different color when the check is placed in it?) . . .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Pop-Up quiz Window with yes no questions 0
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
How do I create a computer admin'd multiple choice test in Excel? 1
How to call module function or sub from the Add In? 3
How to display an "icon" instead of cell value 1
Create Excel Lab test results 1
How do I Create a Macro to run VB Code in Excel? 7
creating a macro icon 1

Back
Top