I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.

Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
--
Brevity is the soul of wit.


"yogamitch" wrote:

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.

so is there anything I can insert into particular cells in order to select or
deselect them?

"Dave F" wrote:

Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
--
Brevity is the soul of wit.


"yogamitch" wrote:

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.

Hi, upon looking into it, I figured out the following.

if you insert a check box, and right click on it, and select format control,
you can tell excel to tie the object to a particular cell. Click on the
Properties tab in the format control dialogue box and select the option "move
and size with cells." This seems to do what you're looking for.
--
Brevity is the soul of wit.


"yogamitch" wrote:

so is there anything I can insert into particular cells in order to select or
deselect them?

"Dave F" wrote:

Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
--
Brevity is the soul of wit.


"yogamitch" wrote:

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.

Thanks for your efforts Dave. It solved the problem to an extent but has not
given me quite what I'd wanted to achieve! I think i'll just take the easy
option... Cheers!

"Dave F" wrote:

Hi, upon looking into it, I figured out the following.

if you insert a check box, and right click on it, and select format control,
you can tell excel to tie the object to a particular cell. Click on the
Properties tab in the format control dialogue box and select the option "move
and size with cells." This seems to do what you're looking for.
--
Brevity is the soul of wit.


"yogamitch" wrote:

so is there anything I can insert into particular cells in order to select or
deselect them?

"Dave F" wrote:

Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
--
Brevity is the soul of wit.


"yogamitch" wrote:

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.

I did as you suggested, but I cannot select that option... it is not
available - it's there, you can see it, but not select it.... ????
--
Pat


"Dave F" wrote:

Hi, upon looking into it, I figured out the following.

if you insert a check box, and right click on it, and select format control,
you can tell excel to tie the object to a particular cell. Click on the
Properties tab in the format control dialogue box and select the option "move
and size with cells." This seems to do what you're looking for.
--
Brevity is the soul of wit.


"yogamitch" wrote:

so is there anything I can insert into particular cells in order to select or
deselect them?

"Dave F" wrote:

Checkboxes are objects which float on top of the spreadsheet, and therefore
are not tied to particular cells.

You insert a checkbox by opening the Control toolbar and drawing the box to
suit your needs. You will see in the formula bar something like the
following: =EMBED("Forms.CheckBox.1","")

Dave
--
Brevity is the soul of wit.


"yogamitch" wrote:

I am an ambulance technician and am setting a basic spreadsheet up to
maintain a record of every patient. Thus, I need to be able to insert a
tick-box into specific cells in order to record the various treatments given.
I'm probably an idiot but I can only find a control which allows a 'floating'
box, and not one which refers to specific cells.