Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Check box - how does one make it tick ?

  1. #1
    Join Date
    20th September 2005
    Location
    Sydney AUSTRALIA
    Posts
    52

    Check box - how does one make it tick ?

    Howdy oh l337fully knowledgable ones.

    I have a Word file. It's a simple chart with which I have filled with check boxes. Basically, I can't figure out how to make the little ticks appear inside the box? I've searched thru my help files, and read some stuff on ActiveX controls, but none of it makes any sense.

    The ticks don't really need to be attached to any macro per se. They're mostly there for appearance, and the file will ultimately be converted to pdf for hosting on the web.

    Currently if I click on the check box, it brings up a properties table, but not the tick. Please...for the love of God...how do I make the damn tick appear ???


    Many of the largest lumps of thanks to my saviours in advance.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313

    Re: Check box - how does one make it tick ?

    Hi,

    If the checkbox is from the controls toolbox it sounds like you are still in design mode.

    Cheers
    Andy


  3. #3
    Join Date
    20th September 2005
    Location
    Sydney AUSTRALIA
    Posts
    52

    Re: Check box - how does one make it tick ?

    So how do I get out of design mode ?

    Sorry, I'm not much good at Word.

    Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313

    Re: Check box - how does one make it tick ?

    First display the controltoolbox toolbar.
    View > Toolbars > Control Toolbox.

    On there is a design button, which is the triangle/ruler/pencil icon.

    Cheers
    Andy


  5. #5
    Join Date
    20th September 2005
    Location
    Sydney AUSTRALIA
    Posts
    52

    Re: Check box - how does one make it tick ?

    woohoo! Yay for Andy. It's done! Thanks man. Hey, while you're here, is there any way to get the actual box to centre? I'm not using any text, and the check box only wants to align to the left or right in the properties. Also, can I change the colour of the tick? Or is it 'be happy with black !!!'

    Thaaaaaankyouuuuuu.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313

    Re: Check box - how does one make it tick ?

    You can not center the checkbox within the control only the line of the document.
    If you have no caption you could set the AutoSize = TRUE which will reduce the white space around the control.

    I think you are stuck with black for the tick itself.

    Cheers
    Andy


  7. #7
    Join Date
    20th September 2005
    Location
    Sydney AUSTRALIA
    Posts
    52

    Re: Check box - how does one make it tick ?

    Cool. Thanks man.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Tick Or Check Box For Allowable Choices
    By Kully in forum EXCEL HELP
    Replies: 1
    Last Post: August 8th, 2008, 20:31
  2. Plot/Chart Tick/Check Marks
    By [sHaQ] in forum EXCEL HELP
    Replies: 5
    Last Post: April 21st, 2008, 18:34
  3. Replies: 6
    Last Post: January 11th, 2007, 04:38
  4. Select/Tick/Check A Checkbox Via Vba Code
    By quddusaliquddus in forum EXCEL HELP
    Replies: 5
    Last Post: October 2nd, 2006, 02:24
  5. Replies: 2
    Last Post: August 27th, 2003, 04:13

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
  •  
porno