+ Reply to Thread
Results 1 to 3 of 3

Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more thing

  1. #1
    Registered User
    Join Date
    07-05-2019
    Location
    Portland
    MS-Off Ver
    Microsoft Office Professional Plus
    Posts
    1

    Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more thing

    So i have built a database of the 2019 NBA draftees and their raw stats. For what I want, it is almost complete. Its essentially consists of raw data from basketball-reference.com and other type of sites. Yesterday, I finished inputting a "google-like" drop-down combo box to search by player name. The combo box works great. as i am typing in a players name, the more i type, the smaller the drop down for names becomes, until eventually, i find the player that I am looking for and click it.

    This issue is, is when i select the player, nothing happens. i need it to where once i select the name and press/click enter, it jumps me straight to the cell where the players name actually is. I have a column named "players". to the right of each player has all of their raw stats, so its just a matter of somehow telling excel that when you select a name from the drop down, or you completely disregard what is being shown in the drop down and you simply finish typing out the full name and hit enter, that it directs me to that players name in their associated cell, under the column listed as "player".

    I wouldn't call myself a Noob, but this issue i have is troubling me to a fair degree. Here are some screenshots below that should give you a better idea as to what I am talking about.
    201 nba database main issue explained.JPG

    NOTE: I HAVE ADDED A SAMPLE WORKBOOK. PLEASE LET ME KNOW IF THE WORKBOOK WORKS FOR YOU OR IF YOU HAVE AND QUESTIONS, COMMENTS OR CONCERNS REGARDING IT AND i WILL GLADLY TAKE ALL HINTS, TIPS. AND CONSTRUCTIVE CRITICISM IN ORDER FOR MY ISSUE TO BE SOLVED. THANK YOU FOR TAKING THE TIME TO READ THIS TODAY.
    Last edited by geehowey; 07-05-2019 at 08:20 AM. Reason: Added Excel workbook

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,689

    Re: Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more t

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,910

    Re: Built 2019 NBA Draft Database. built dropdown combo-box for all players. need 1 more t

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Search Excel database with multiple criteria to simulate the built-in data entry form
    By DanB22000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2014, 09:42 PM
  2. invoice-like material list with built in database
    By Riebau in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2013, 04:55 PM
  3. How I can built combo box step by step
    By Vasant Nanavati in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  4. How I can built combo box step by step
    By Friends2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. Combo Boxes built with Control Toolbox on a Worksheet
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2005, 07:05 AM
  6. How Can I Update the database file from "Excel" and Built the ent.
    By Kenneth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2005, 12:06 AM

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