Excel copying heading to another cell in a selection is made
 

I have created a form with a checklist. I want it to automatically place the
label of the box "A" in another cell when a "X" is place in checkcell.
--
Mike

Excel copying heading to another cell in a selection is made
 

Hi Mike,

Not sure we are on the same wave length here. Can you provide some more
information.
When you say you have created a form, do you mean a Userform created in VBA
or simply set out data in a form format on an excel worksheet?
What sort of object is Box "A". Is it a text box or what? What do you mean
by a label? Is it a cell label?
The form with the check list. What is the check list in? Is it a List box or
what?


--
Regards,

OssieMac


"Mike" wrote:

I have created a form with a checklist. I want it to automatically place the
label of the box "A" in another cell when a "X" is place in checkcell.
--
Mike

Excel copying heading to another cell in a selection is made
 

I created a simple form like a sales invoice. The box is a text box that I
put an "X" in. The label it the title of the box. I want to put an "X" in
the box and have the label appear in another cell.
--
Mike


"OssieMac" wrote:

Hi Mike,

Not sure we are on the same wave length here. Can you provide some more
information.
When you say you have created a form, do you mean a Userform created in VBA
or simply set out data in a form format on an excel worksheet?
What sort of object is Box "A". Is it a text box or what? What do you mean
by a label? Is it a cell label?
The form with the check list. What is the check list in? Is it a List box or
what?


--
Regards,

OssieMac


"Mike" wrote:

I have created a form with a checklist. I want it to automatically place the
label of the box "A" in another cell when a "X" is place in checkcell.
--
Mike

Excel copying heading to another cell in a selection is made
 

Hi again Mike,

I am still confused. A Text Box is an object created from the Control
Toolbox toolbar in pre 2007 versions of xl and in 2007 version created from
the Insert button on the Developer tab of the ribbon. To the best of my
knowledge they do not have a Title (or Caption) so still cannot help you.

--
Regards,

OssieMac


"Mike" wrote:

I created a simple form like a sales invoice. The box is a text box that I
put an "X" in. The label it the title of the box. I want to put an "X" in
the box and have the label appear in another cell.
--
Mike


"OssieMac" wrote:

Hi Mike,

Not sure we are on the same wave length here. Can you provide some more
information.
When you say you have created a form, do you mean a Userform created in VBA
or simply set out data in a form format on an excel worksheet?
What sort of object is Box "A". Is it a text box or what? What do you mean
by a label? Is it a cell label?
The form with the check list. What is the check list in? Is it a List box or
what?


--
Regards,

OssieMac


"Mike" wrote:

I have created a form with a checklist. I want it to automatically place the
label of the box "A" in another cell when a "X" is place in checkcell.
--
Mike