Results 1 to 6 of 6

Clear ALL combo Box

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2008
    Posts
    36

    Clear ALL combo Box

    Hi,

    How do I clear all combobox at one time?

    Now i am clearing it one by one and i forsee that if i have alot of combobox, this list will go a long way..

    Private Sub Worksheet_Activate()
    '* OFF screenupdating to speed up the process
    Application.ScreenUpdating = False
    
    HFD = Sheets("Project List").Range("A65536").End(xlUp).Row
    
    HFR = Sheets("Project List").Range("IV4").End(xlToLeft).Column
    
    ComboBox1.Clear
    ComboBox2.Clear
    ComboBox3.Clear
    ComboBox4.Clear
    ComboBox5.Clear
    ComboBox6.Clear
    ComboBox7.Clear
    ComboBox8.Clear
    ComboBox9.Clear
    ComboBox10.Clear
    
    For N = 3 To HFD
        With ComboBox1
            .AddItem Sheets("Project List").Cells(N, 1).Value
        End With
    Next N
    
    
    Application.ScreenUpdating = True
    
    End Sub
    Last edited by jieyi; 03-13-2009 at 05:10 AM.

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