Re: Automatically naming and linking controls

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dylan,

Thank you for sharing your perspective. Chip Pearson has also given some suggestions for coding a solution that may help automate this task. Might be nice if Microsoft would provide some sort of a naming/renaming and linking/re-linking utility that would allow the user to quickly select groups of obects and provide them with sequential names or links for fields of this nature. Especially since it looks like it might be fairly easy to code a general purpose utility.

Thanks,
Richard

**********
"Dylan @ UAFC" <DylanUAFC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4B160D2E-570F-4C15-B6D2-A464ACE732AA@xxxxxxxxxxxxxxxx
You might be in a territory were you would be better
using some type of SQL server code.

Im as familiar with VBA in excel, but I really don't think
you can achieve this with traditional formula or functions

"Blue Max" wrote:

We are developing worksheets where we have a tall column of checkboxes with
the checkbox linked to the cell beneath each control. We also want to
sequentially name each control, starting at the top of the column, with a
standard prefix concatenated to a sequential number. Next, we want to link
each of those controls with the cell directly beneath it.

Understandably, manually typing the '(Name)' and 'LinkedCell' property for
each control is a bit frustrating. Unlike, copying formulas down a column,
the linked cell reference for the control does not automatically adjust the
cell link as a new control is pasted over a new cell. Does anybody have any
thoughts on simplifying or automating this process?


.

Relevant Pages

  • Re: Text box date format
    ... It's a userform & the controlsource property is linked to the cell. ... If it is on the worksheet and from the Control Toolbox, ... TextBox linked to a particular cell via the LinkedCell property ...
    (microsoft.public.excel.programming)
  • RE: Working with Visual Basic Check bo contrls
    ... linked cell property manually for all 500 chk boxes may be time consuming. ... If you add the control toolbox, the property box can be manually set ... From another addin you don't need to use the linkedcell because you can read ...
    (microsoft.public.excel.programming)
  • Re: Text box date format
    ... It's a userform & the controlsource property is linked to the cell. ... where did you get the TextBox from... ... If it is on the worksheet and from the Control Toolbox, ... TextBox linked to a particular cell via the LinkedCell property ...
    (microsoft.public.excel.programming)
  • Re: Automatically naming and linking controls
    ... Thank you very much, Chip. ... I selected this check box from the Excel 2007 Developer Tab> Control Section> Insert Button> ActiveX Controls group. ... Will this method still work if the 'Check Box' object was drawn using the 'ALT' key to snap the object corners to the cell corners? ... THIRD, I also assume that I can assign the 'LinkedCell' property by specifying a column letter, concatenated with an incrementing number, seeded with the proper beginning row number, correct? ...
    (microsoft.public.excel.worksheet.functions)
  • Epigenetic Control of the Postphylotypic Development
    ... Epigenetic Control of the Postphylotypic Development ... inducing there muscle cell differentiation and muscle formation ... of Muscle Research and Cell Motility 23: ... Epigenetics of the Development of Endocrine Glands ...
    (talk.origins)