+ Reply to Thread
Results 1 to 10 of 10

Data Validations horizonatl dropdown menu?

  1. #1
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    Data Validations horizonatl dropdown menu?

    Is it possible to make data validations list menu in horizontal position?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Data Validations horizonatl dropdown menu?

    Yes.......


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Data Validations horizonatl dropdown menu?

    heheh Ok than would u mind to share how to do it?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Data Validations horizonatl dropdown menu?

    Sure.....

    But please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

  5. #5
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Data Validations horizonatl dropdown menu?

    No problem Let me present u my problem...
    Attached Images Attached Images
    Attached Files Attached Files

  6. #6
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data Validations horizonatl dropdown menu?

    Make the column wider!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Registered User
    Join Date
    02-17-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Data Validations horizonatl dropdown menu?

    It is not a decision

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Data Validations horizonatl dropdown menu?

    I am seeing only one option in this case (i.e.) just going for VBA approach.

    On selection of F2 cell the column width will expand and on exit the column width will be re assigned. No other go I believe.

  9. #9
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data Validations horizonatl dropdown menu?

    You don't have many options, then.

    See if you can use anything here:

    http://www.contextures.com/xlDataVal08.html#Wider

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Data Validations horizonatl dropdown menu?

    Copy the below code and do right click on the sheet tab and select view code and paste the below code.

    Return to excel and checků

    Please Login or Register  to view this content.
    Save the file as Macro Enabled file .xlsm and when opening the file Enable the Macros.

    Refer the attached file for details
    Attached Files Attached Files

+ 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. Autofill data by Dropdown menu
    By JethroJohn in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 04-07-2011, 02:30 PM
  2. Dropdown Menu Data no longer visible...
    By tricialynn75 in forum Excel General
    Replies: 5
    Last Post: 03-03-2009, 08:38 PM
  3. Import data from dropdown menu on internet
    By r1984 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-15-2008, 05:56 PM
  4. Create Dropdown menu without using the Validation on the Data Menu
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-13-2006, 03:47 PM
  5. Using a dropdown menu for Data Querying
    By derekrap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 02:24 PM

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