I am a bit confused  about using the checkbox. I have a paper form  that I need to
fill out based on information  I collect in the field. I am using a palm pilot to
gather information in the field. I then have to import a tab delimited file into
excel.
For some of the questions, I use checkboxes  on the palm pilot, the return value
in the imported file is 1, 2, 3, 4, 5 etc..., the number corresponds to the
checkbox that is chosen on the palm pilot. If the imported file gives the cell  a
value of 1, 2, 3, 4, or 5; can I just put the formula (=cl2=1 etc...) in the
corresponding checkbox in excel? I have tried it to no avail. Can I format the
checkbox (in excel) to be checked if the corresponding cell has a certain
number? ie. checkbox 1 is true if CL2=1, checkbox 2 is true if CL2=2, checkbox 3
is true if CL2=3, etc... .
Thanks for the help with the textboxes, they work just fine.