Populate combox with sheet names and copy userform data to selected sheet

  • Re: Select Worksheet Based on ComboBox


    If you mean the you want the code to select the sheet depending on the combobox value then something like this.

    Code
    dim x as string
    x= ComboBox1.value & "*"
    
    
    sheets(x).select
    'run  your code..

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!