Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Combo box macro question

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everyone.

    I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).

    Can i do this all with a macro?

    Thanks

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 18:29, robfo0 wrote:
    Hi everyone.

    I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).

    Can i do this all with a macro?

    Thanks
    Forms Combobox ?? then Try

    ActiveSheet.Shapes("CMB_BOX1").ControlFormat.LinkedCell = "$A$1"

    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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