+ Reply to Thread
Results 1 to 2 of 2

Editing User Defined Lists - Beginner

  1. #1
    Registered User
    Join Date
    10-31-2006
    Posts
    1

    Editing User Defined Lists - Beginner

    I'm looking to create Macro's which will enable me to edit my UDL's then update their location for drop down box purposes.

    As it stands I have long lists of data that are used by cells for drop down validation purposes. It is imperitive for me to be able to add/delete and edit these lists automatically and for this to update into my drop down cells.

    Ideally I'm looking for a macro(for adding data) which will either create an input box or go to next free cell in my desired list depending on the macro. The new list then will be updated into my defined name list which will then be able to be accessed from the drop down box.

    Any help would be really appreciated.

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Red face Add Item to ComboBox

    Here's an example to Add items to a ComboBox, Maybe it will work for your needs
    Attached Files Attached Files

+ 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