+ Reply to Thread
Results 1 to 8 of 8

Delete Row / Cell from ComboBox Selection

  1. 02-20-2017, 08:11 PM #1
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Delete Row / Cell from ComboBox Selection

    .
    .
    See comments in RED

    Please and thank you ! 


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-20-2017, 08:34 PM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Delete Row / Cell from ComboBox Selection

    Try this for starters.

    Please Login or Register  to view this content.
    PS Deleting rows is not an option because that will affect your other lists as well.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
  3. 02-20-2017, 09:40 PM #3
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Delete Row / Cell from ComboBox Selection

    Thanks bakerman2 ... that clears the affected cell. Now I will figure out how to remove the blank cell and move the remaining data below up one line.
    Reply With QuoteRegister To Reply
  4. 02-20-2017, 09:52 PM #4
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Delete Row / Cell from ComboBox Selection

    Got it. Thanks bakerman2 !

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-20-2017, 10:02 PM #5
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Delete Row / Cell from ComboBox Selection

    You're welcome.
    Reply With QuoteRegister To Reply
  6. 02-20-2017, 10:29 PM #6
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Delete Row / Cell from ComboBox Selection

    Tried to give you some more Add Rep but it won't let me.

    Hmm .....
    Reply With QuoteRegister To Reply
  7. 02-21-2017, 05:24 AM #7
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Delete Row / Cell from ComboBox Selection

    It's the thought that counts.
    Reply With QuoteRegister To Reply
  8. 02-21-2017, 08:11 AM #8
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Delete Row / Cell from ComboBox Selection

    "Time to make the donuts."

    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. Combobox selection / Delete row after saving in another sheet / Run-time error '1004'
    By Arvin.Amaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2015, 07:27 PM
  2. [SOLVED] Delete Row based on combobox selection deleting entire range
    By SHUTTEHFACE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-19-2014, 09:40 AM
  3. [SOLVED] fill combobox selection based on a selection from the first combobox
    By Monza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 07:34 PM
  4. Fill a cell via textbox according to combobox selection
    By dj_danu01 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2013, 08:12 AM
  5. [SOLVED] Populate Cell on Combobox Selection
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2013, 08:03 AM
  6. automatic cell selection from combobox
    By promiltje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 12:43 PM
  7. ComboBox Selection to a Cell
    By CESAR V. ARROYO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2012, 02:04 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