Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Drop Down Box - VBA

  • 16-06-2008 9:13am
    #1
    ncarroll
    Closed Accounts Posts: 30 ✭


    Hi, I need help with VBA. I want to display this drop down box in a form, not a spreadsheet. I want the user to open excel, hide the spreadsheet, just display a form, with a dropdown box for surname, a drop down for organisation, and a drop down for positions. This allows a spreadsheet to list all the detail based on the users selection, i.e. view all people named Noel, or view all CEOs within the DB, or view all personell asociated with Company X. 3 choices, 3 dropdown boxes, 2 buttons (search & exit).


    Any suggestions....?


    Noel:confused:


Comments

  • #2
    Ginger
    Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭Ginger


    Just add the drop downs to excel (in Excel 2007 its in the Developer tab) and then set some VBA code against the onSelect methods and off you go

    Alternatively, you could use a query and have the dropdown type as lists


Advertisement