Results 1 to 6 of 6

Thread: Combobox with Dynamic Date Range

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    You only need the userform initialize code.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    14
    Thanks Admin...yes got it to know work...playing around with the code so as to learn for the rest of the userform

    My only other question I have is if I change the dates to a different numbered Combobox do I just change this line in the code

    Code:
    With Me.ComboBox1
    Example:So if I want the dates to appear in the combobox3 on my userform I change the code above from combobox1 to combobox3..The reason I ask is I have tried but it failed.I am learning as I go but I am changing the code as I think to work

    Paul

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  2. Combobox Not Working In Excel Workbook Shared Mode
    By peter renton in forum Excel Help
    Replies: 15
    Last Post: 06-03-2013, 01:25 PM
  3. How to make Dynamic range (width) with OFFset function
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 12
    Last Post: 12-01-2012, 11:03 PM
  4. Combobox VBA update value worksheet
    By Tony in forum Excel Help
    Replies: 4
    Last Post: 10-28-2012, 12:28 AM
  5. Sum Ifs Formula needed with Max Date range
    By trankim in forum Excel Help
    Replies: 2
    Last Post: 09-19-2012, 09:50 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •