+ Reply to Thread
Results 1 to 3 of 3

VBA Usefrom Combo Box: Select starting point of drop down data

  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    Sao Paulo, Brasil
    MS-Off Ver
    Excel 2010
    Posts
    19

    VBA Usefrom Combo Box: Select starting point of drop down data

    Hi,

    Is there any way to set the list from a Combo Box to automatically start in the middle?

    Whenever I select a Combo Box, the drop down list always automatically starts at the top of my selected range, ideally I would like it to start in the middle.

    For example my Range that I am filling the Combo Box with lists dates: Today()-7 to Today()+7.

    At the moment the first item in the combo box list is Today()-7, I would like it to be Today().

    Is this possible?

    Many thanks in advance,


    Benedict

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: VBA Usefrom Combo Box: Select starting point of drop down data

    This code run in The "Sheet_Activate" module will change the combobox to todays date each time the sheet is activated.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-06-2014
    Location
    Sao Paulo, Brasil
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: VBA Usefrom Combo Box: Select starting point of drop down data

    Hi MickG,

    Thanks for getting back to me.

    This is not exactly what I would like to do.

    I already have a named range which contains Today()-7 to Today()+7; this is the range that populates the Combo Box.

    As it stands, when I select the ComboBox the first date that I am shown is Today()-7.
    I would like it to start in the middle with Today().

    I do not know if this is possible

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Find or Search to extract data starting point from a formula
    By mike_vr in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-08-2014, 12:31 PM
  2. [SOLVED] VBA to copy data using 'Yes' as a starting point
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 05-28-2013, 06:30 AM
  3. Data Validation - Can I change the starting point?
    By FSUdawg85 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2013, 09:54 AM
  4. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  5. selecting starting point in drop down list
    By -Brian-H- in forum Excel General
    Replies: 0
    Last Post: 08-29-2006, 12:34 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