View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
dan dungan dan dungan is offline
external usenet poster
 
Posts: 411
Default Can a checkbox be created with a logic function?

I accidentally sent the previous message before I was finished.

What I meant was:

In excel 2000 on my computer, the wingdings 2 font has Character code
0x52 which shows R until you change the font to wingdings2. Then you
see the check mark in a box.

Character code 0x2A shows R* which is an empty box.

So if you are evaluating A1 the formula,
=IF(A1="",R*,R)

Dan