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

How to create yes/ no box for selection? 6
How to create a group combo box (Yes/No)? 16
How to create a pull down lists? 1
How to change the font size for text within check box? 1
How to create (Yes/NO) check boxes in Excel cells? 8
How to count the number of selected combobox within Excel? 10
How to change the font size for check box? 3
How to create a customized icon for specific filename within toolb 4

Top