+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Marauder1
    Guest

    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. #2
    sebastienm
    Guest

    RE: 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. #3
    Marauder1
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1