Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms (XL97:SR2)

    Is it possible to delete the name assigned to a ComboBox which is located in "NameBox" (directly above Column A? I recently renamed a ComboBox and need to delete the old reference. Example: Drop Down 2 was changed to Drop Down 3.

    Note!-Drop Down 3 was not inserted as a form

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Forms (XL97:SR2)

    Not much to go on but...
    Are you sure you didn't create a brand new drop-down thats stacked right on top of
    the old drop down?

    Jim Cone
    San Jose, CA

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Forms (XL97:SR2)

    If you delete the ComboBox, the name goes with it.

    If you need to rename the combobox, just type the new name in the NameBox whilst the Combo box is selected. This should remove the old name.

    Andrew C

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Forms (XL97:SR2)

    Andrew,
    Did you get my e-mail from yesterday?
    Jeff

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Forms (XL97:SR2)

    Yes, but it has no relevance to this thread.

    Andrew C

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (XL97:SR2)

    If I save the file, exit XL completely and open the file again there seems to be an internal resetting of the names associated with new ly created combo boxes. Thus incrementing them in the correct order.

    Thanks to all who responded,
    John

Posting Permissions

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