+ Reply to Thread
Results 1 to 2 of 2

Automatating Validation List Selection

  1. #1
    Forum Contributor
    Join Date
    10-04-2006
    Posts
    151

    Automatating Validation List Selection

    Hello again everyone!

    I was wondering: In my worksheet I have a validation list which is used to select phrases. In the next cell below I have a Vlookup statement to get the info to the corresponding phrase. I do this every time I open the worksheet.

    Is there a way that Excel can automatically go to the next phrase upon file open instead of me manually selecting it from a drop down menu? I have attached a small workbook....

    TIA
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Try this macro which you need to paste into the ThisWorkbook tab in the VBA editor (Shift F11)

    Please Login or Register  to view this content.
    Martin

+ Reply to Thread

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