Check box

I have a user that wants to put a checkmark in a cell as a yes or no to each
record (row) that either has a contract or not.
I tried putting in the form field but that really doesn't seem to be it.
I tried to talk her into simply putting an X in the cell but she would
really rather the checkmark.

Any ideas??

Dave French

Change the cell to Wingdings font, then, holding the Alt key down, type 0252
on the numeric keypad (not regular #s), then let go of the Alt key. Or,
enter =CHAR(252).

Bob Umlas
Excel MVP

"David French" <[email protected]> wrote in message
news:[email protected]...
> I have a user that wants to put a checkmark in a cell as a yes or no to
each
> record (row) that either has a contract or not.
> I tried putting in the form field but that really doesn't seem to be it.
> I tried to talk her into simply putting an X in the cell but she would
> really rather the checkmark.
>
> Any ideas??
>
> Dave French
>
>

I belive font Webdings with a lowercase 'a' will get similar results.

Mark

"Bob Umlas" <[email protected]> wrote in message
news:[email protected]...
> Change the cell to Wingdings font, then, holding the Alt key down, type
> 0252
> on the numeric keypad (not regular #s), then let go of the Alt key. Or,
> enter =CHAR(252).
>
> Bob Umlas
> Excel MVP
>
> "David French" <[email protected]> wrote in message
> news:[email protected]...
>> I have a user that wants to put a checkmark in a cell as a yes or no to
> each
>> record (row) that either has a contract or not.
>> I tried putting in the form field but that really doesn't seem to be it.
>> I tried to talk her into simply putting an X in the cell but she would
>> really rather the checkmark.
>>
>> Any ideas??
>>
>> Dave French
>>
>>
>
>

as will Marlett and 'a'

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mark" <[email protected]> wrote in message
news:[email protected]...
> I belive font Webdings with a lowercase 'a' will get similar results.
>
> Mark
>
> "Bob Umlas" <[email protected]> wrote in message
> news:[email protected]...
> > Change the cell to Wingdings font, then, holding the Alt key down, type
> > 0252
> > on the numeric keypad (not regular #s), then let go of the Alt key. Or,
> > enter =CHAR(252).
> >
> > Bob Umlas
> > Excel MVP
> >
> > "David French" <[email protected]> wrote in message
> > news:[email protected]...
> >> I have a user that wants to put a checkmark in a cell as a yes or no to
> > each
> >> record (row) that either has a contract or not.
> >> I tried putting in the form field but that really doesn't seem to be
it.
> >> I tried to talk her into simply putting an X in the cell but she would
> >> really rather the checkmark.
> >>
> >> Any ideas??
> >>
> >> Dave French
> >>
> >>
> >
> >
>
>

Thank you ALL!!
These are all great suggestions and my user is very happy!!

Dave French


"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> as will Marlett and 'a'
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Mark" <[email protected]> wrote in message
> news:[email protected]...
>> I belive font Webdings with a lowercase 'a' will get similar results.
>>
>> Mark
>>
>> "Bob Umlas" <[email protected]> wrote in message
>> news:[email protected]...
>> > Change the cell to Wingdings font, then, holding the Alt key down, type
>> > 0252
>> > on the numeric keypad (not regular #s), then let go of the Alt key. Or,
>> > enter =CHAR(252).
>> >
>> > Bob Umlas
>> > Excel MVP
>> >
>> > "David French" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> I have a user that wants to put a checkmark in a cell as a yes or no
>> >> to
>> > each
>> >> record (row) that either has a contract or not.
>> >> I tried putting in the form field but that really doesn't seem to be
> it.
>> >> I tried to talk her into simply putting an X in the cell but she would
>> >> really rather the checkmark.
>> >>
>> >> Any ideas??
>> >>
>> >> Dave French
>> >>
>> >>
>> >
>> >
>>
>>
>
>