How to create a checkk box?

E

Eric

Does anyone have any suggestions on how to create a check box on Excel?
I would like to create a list of items with a check box on next column.
Does anyone have any suggestions on how to do it?
Thanks advance for any suggestions
Eric
 
J

Jacob Skaria

Dear Eric

You can play around with fonts to acheive this..

1. Adjust the colum width to look like a square box.
2. Set the font for that column to Marlett
3. Type lower case 'a' for tick mark or 'r' for cross mark.
4. Apply borders if you would like to

If this post helps click Yes
 
F

FARAZ QURESHI

oNCE aGAIN eXCELLENT jACOB!!!

Correct me if I am wrong it rather seems that like for Text Types the
variable needs to be declared as Variant rather than String?
 

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

Content Control Box Issue - Please Help! 0
Word OLE to check spelling in text box 1
Possible to Combine reports to's to a single box? 0
Populate a table based on check box status 2
Setting language of a selected text in Office apps. 0
How to create (Yes/NO) check boxes in Excel cells? 4
How to create a pull down lists? 2
How to create yes/ no box for selection? 3

Top