They are simply option buttons contained withing a square 'frame'

Be careful, there are two types, 1 is an Excel control and 1 is a VBA control.

Show the toolbar 'Control Toolbox' (or is it 'Forms', I cant remember which
is which). Click the option button-button and 'draw' it on your sheet.
right-click and format the control to link to a specific cell. When you have
4 controls, as you click each one, an 'index' number will appear in the cell
you linked to. From there a simple vlookup will work.

Hope that helps


"Dirty Monkey" wrote:

Hope this makes sense.... I am looking to do a list.. only 4 choices in
excel. I want all 4 to be displayed with a circle (or square!!) next to each
one. To highlight the selection the circle will be filled on pressing the
mouse over it.
This must be simple to do as it is on most websites where you select yes or
no..... but I cant work out how to do it!!!!!! In fact its at the bottom of
this page where you select "I accept" or "I do not accept"!!!
I would be really grateful for your response.

Many thanks