+ Reply to Thread
Results 1 to 6 of 6

Userform to add or delete items from column

  1. 01-29-2016, 02:36 PM #1
    ste67@me.com
    ste67@me.com is offline
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Userform to add or delete items from column

    Hi everyone i have a problem i have no vba knowledge and need help please.

    LIST OF NAMES IN COLUMN A
    NEED HELP WITH USERFORM
    LISTBOX1 NEEDS TO SHOW ALL NAMES IN SHEET AND MUST SCROLL AS LIST EXPANDS
    TEXTBOX1 TO ENTER NAME AND AUTO SEARCH ON ENTER OR CLICKING OFF BOX.
    TEXTBOX2 TO DISPLAY THAT THE NAME ALREADY EXISTS OR DOES NOT EXIST AFTER SEARCH
    FINALLY COMBOBOXES TO EITHER ADD OR DELETE NAMES TO LIST

    I hope that its an easy project for an experienced coder
    regards Steve
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-29-2016, 03:07 PM #2
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Userform to add or delete items from column

    LISTBOX1 NEEDS TO SHOW ALL NAMES IN SHEET AND MUST SCROLL AS LIST EXPANDS
    Modify the listbox in the property for scroll bars
    Please Login or Register  to view this content.
    TEXTBOX1 TO ENTER NAME AND AUTO SEARCH ON ENTER OR CLICKING OFF BOX.
    TEXTBOX2 TO DISPLAY THAT THE NAME ALREADY EXISTS OR DOES NOT EXIST AFTER SEARCH 
    Please Login or Register  to view this content.
    FINALLY COMBOBOXES TO EITHER ADD OR DELETE NAMES TO LIST
    I'll assume you mean command buttons.
    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  3. 01-29-2016, 03:17 PM #3
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Userform to add or delete items from column

    See if this gets you close.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
  4. 01-29-2016, 03:31 PM #4
    ste67@me.com
    ste67@me.com is offline
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Userform to add or delete items from column

    Thank you for your time it doesnt seem to be working ive added your code to new workbook
    hope its fixable
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 01-29-2016, 03:36 PM #5
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Userform to add or delete items from column

    Replace this part:

    Please Login or Register  to view this content.
    Everything else worked as requested.
    Reply With QuoteRegister To Reply
  6. 01-29-2016, 03:45 PM #6
    ste67@me.com
    ste67@me.com is offline
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Userform to add or delete items from column

    Thank you so much works so good A111
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete duplicate items in list in userform
    By CtrlAltDelete in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2014, 11:30 AM
  2. [SOLVED] code for userform to delete combo box value from dynamic range & move column up
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-02-2014, 07:42 PM
  3. Move/Delete items between multiple list boxes in a UserForm that correspond to tables
    By salvo2002 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2014, 07:43 PM
  4. [SOLVED] Adding new items to Multi-Column Listbox on seperate Userform
    By Hutinni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2013, 02:43 PM
  5. delete items in column B from column A
    By seph in forum Excel General
    Replies: 3
    Last Post: 01-07-2010, 06:41 PM
  6. [SOLVED] Disable Menu Items Insert/Delete Entire Column(s)
    By JR_06062005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2006, 02:30 PM
  7. Delete bolded items in column
    By Annette in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2005, 03:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1