Results 1 to 13 of 13

Delete combo boxes

Threaded View

  1. #10
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK/Australia
    MS-Off Ver
    365
    Posts
    135

    Re: Delete combo boxes

    OK now I understand that Jindon's code is suitable.

    But I couldn't get a loop to work though.
    If possible please revise and compare to a name like "*Drop Down To Del*", so it will delete only these drop downs. I should have mentioned that at the start.

    Sub del()
        Dim obj As Object
        For Each obj In ActiveSheet.DropDowns
            If ActiveSheet.DropDowns = xlDropDown Then
            ActiveSheet.DropDowns.Delete
            End If
        Next
    End Sub
    Last edited by lb_33; 08-28-2022 at 10:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Suddenly unable to use text boxes/combo boxes on my computer
    By eawesley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2020, 10:28 AM
  2. How to link combo boxes and list boxes in VBA using active x controls
    By LaSouth1776 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2020, 12:46 PM
  3. [SOLVED] Delete a row based on value of 2 combo boxes (2 columns)
    By kevo1588 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2017, 11:44 AM
  4. [SOLVED] Help with code for userform text boxes, combo boxes and excel
    By innerise in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2014, 09:07 AM
  5. populating list boxes and combo boxes in a user form.
    By ahceinaej in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:54 AM
  6. assigning data to lists boxes and combo boxes in userforms
    By weston.roberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2011, 03:11 AM
  7. assigning data to lists boxes and combo boxes in userforms
    By weston.roberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2011, 08:46 PM

Tags for this Thread

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