+ Reply to Thread
Results 1 to 5 of 5

Linked Cell Property In Activex controls

Hybrid View

  1. #1
    KG
    Guest

    Linked Cell Property In Activex controls

    Can someone point me to an example showing how this property can be used,
    linking, as an example, an option button to a specific cell? Say if I wanted
    "1" to appear in cell B2 of the worksheet if the option button is clicked

  2. #2
    Earl Kiosterud
    Guest

    Re: Linked Cell Property In Activex controls

    KG,

    The option button puts TRUE or FALSE into its Linked Cell. You can get 1 or
    0 out of that by referring to it with double negation operators.
    = --A1

    --
    Earl Kiosterud
    mvpearl omitthisword at verizon period net
    -------------------------------------------

    "KG" <KG@discussions.microsoft.com> wrote in message
    news:924E6B40-6040-4016-B75B-D65215754A1D@microsoft.com...
    > Can someone point me to an example showing how this property can be used,
    > linking, as an example, an option button to a specific cell? Say if I
    > wanted
    > "1" to appear in cell B2 of the worksheet if the option button is clicked




  3. #3
    KG
    Guest

    Re: Linked Cell Property In Activex controls

    when I try double-negation, the linked cell property turns blank

    "Earl Kiosterud" wrote:

    > KG,
    >
    > The option button puts TRUE or FALSE into its Linked Cell. You can get 1 or
    > 0 out of that by referring to it with double negation operators.
    > = --A1
    >
    > --
    > Earl Kiosterud
    > mvpearl omitthisword at verizon period net
    > -------------------------------------------
    >
    > "KG" <KG@discussions.microsoft.com> wrote in message
    > news:924E6B40-6040-4016-B75B-D65215754A1D@microsoft.com...
    > > Can someone point me to an example showing how this property can be used,
    > > linking, as an example, an option button to a specific cell? Say if I
    > > wanted
    > > "1" to appear in cell B2 of the worksheet if the option button is clicked

    >
    >
    >


  4. #4
    Earl Kiosterud
    Guest

    Re: Linked Cell Property In Activex controls

    KG,

    I don't understand what you're saying. The Linked Cell property is where
    you put a cell address, and won't change unless you change it. If it's set
    to A1, then A1 will have TRUE or FALSE depending on that button state.
    Another cell, let's say B1 for this situation, would have the = -- A1, and
    would reflect 0 or 1 depending on the TRUE or FALSE in A1.

    --
    Earl Kiosterud
    mvpearl omitthisword at verizon period net
    -------------------------------------------

    "KG" <KG@discussions.microsoft.com> wrote in message
    news:B9B2B69C-4106-4EB2-A264-0B5D6D1C81BD@microsoft.com...
    > when I try double-negation, the linked cell property turns blank
    >
    > "Earl Kiosterud" wrote:
    >
    >> KG,
    >>
    >> The option button puts TRUE or FALSE into its Linked Cell. You can get 1
    >> or
    >> 0 out of that by referring to it with double negation operators.
    >> = --A1
    >>
    >> --
    >> Earl Kiosterud
    >> mvpearl omitthisword at verizon period net
    >> -------------------------------------------
    >>
    >> "KG" <KG@discussions.microsoft.com> wrote in message
    >> news:924E6B40-6040-4016-B75B-D65215754A1D@microsoft.com...
    >> > Can someone point me to an example showing how this property can be
    >> > used,
    >> > linking, as an example, an option button to a specific cell? Say if I
    >> > wanted
    >> > "1" to appear in cell B2 of the worksheet if the option button is
    >> > clicked

    >>
    >>
    >>




  5. #5
    KG
    Guest

    Re: Linked Cell Property In Activex controls

    I misunderstood you the first time but I got it now. Thanks for your patience

    "Earl Kiosterud" wrote:

    > KG,
    >
    > I don't understand what you're saying. The Linked Cell property is where
    > you put a cell address, and won't change unless you change it. If it's set
    > to A1, then A1 will have TRUE or FALSE depending on that button state.
    > Another cell, let's say B1 for this situation, would have the = -- A1, and
    > would reflect 0 or 1 depending on the TRUE or FALSE in A1.
    >
    > --
    > Earl Kiosterud
    > mvpearl omitthisword at verizon period net
    > -------------------------------------------
    >
    > "KG" <KG@discussions.microsoft.com> wrote in message
    > news:B9B2B69C-4106-4EB2-A264-0B5D6D1C81BD@microsoft.com...
    > > when I try double-negation, the linked cell property turns blank
    > >
    > > "Earl Kiosterud" wrote:
    > >
    > >> KG,
    > >>
    > >> The option button puts TRUE or FALSE into its Linked Cell. You can get 1
    > >> or
    > >> 0 out of that by referring to it with double negation operators.
    > >> = --A1
    > >>
    > >> --
    > >> Earl Kiosterud
    > >> mvpearl omitthisword at verizon period net
    > >> -------------------------------------------
    > >>
    > >> "KG" <KG@discussions.microsoft.com> wrote in message
    > >> news:924E6B40-6040-4016-B75B-D65215754A1D@microsoft.com...
    > >> > Can someone point me to an example showing how this property can be
    > >> > used,
    > >> > linking, as an example, an option button to a specific cell? Say if I
    > >> > wanted
    > >> > "1" to appear in cell B2 of the worksheet if the option button is
    > >> > clicked
    > >>
    > >>
    > >>

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1