| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel, how do I create a point and click icon?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In Excel, how do I create a point and click icon?
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 -- Regards, Sébastien <http://www.ondemandanalysis.com "Marauder1" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In Excel, how do I create a point and click icon?
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?) . . . "sebastienm" wrote: 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 -- Regards, Sébastien <http://www.ondemandanalysis.com "Marauder1" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does the exclamation point on my MS-Excel file icon mean? | Excel Discussion (Misc queries) | |||
| Create a macro so when I click the icon, the response is the A1 ce | Excel Discussion (Misc queries) | |||
| Change email icon in Excel 2007 to point to Winmail | Excel Discussion (Misc queries) | |||
| why is my excel icon a yellow-white exclamation point now? what . | Excel Discussion (Misc queries) | |||
| Excel 2000...Click on different Worksheet...Get a New icon and can | Excel Discussion (Misc queries) | |||
Linear Mode
