| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data selection and copying | Excel Discussion (Misc queries) | |||
| Combo box disappears after selection made | Excel Discussion (Misc queries) | |||
| Using an Excel VB-made form in cell-specific conditions. | Excel Worksheet Functions | |||
| Resize selection made by "name" VBA | Excel Discussion (Misc queries) | |||
| Choices made available dependent on another selection? | Excel Worksheet Functions | |||
Linear Mode
