Perhaps an easier alternative via data validation ..

Try this ..

Assuming responses yes/no to be made in col B

Select col B
Click Data Validation

In Settings tab:
Allow: List
Source: Yes, No

In Input Message tab,
enter: Select: Yes or No

Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cheryl" wrote in message
...
can somebody please advise how you put a tick box
or a combo box with a yes/no into excel spreadsheet
--
thanks
Cheryl