Formula bar shows a number based on the date selected from another sheet

I have two worksheets in one workbook, one is a dashboard (sheet 1)and the other ones tells it where to grab the data from (sheet2). Example. In B1 of Sheet 1, it will show a number from column B2:B51 in sheet 2, but that number changes based on what date is selected from a drop down list in that same cell B1 of Sheet 1. Each time you change the date from the drop down box in B1 sheet1 it locates that date in Sheet 2 column a2:A51 and shows the number from sheet 2 column B2:b51 in the formula bar in Sheet 1, B1. There must be some special function. It seems there is a formula underneath the drop down list in B1. I am not very good at all with VBA, so I was hoping that I might get some help here. TIA!

What I can't get my spreadsheet to do is (but I have someone's, and I don't know who's because it is protected). On the scorecard tab, in B1, when you are in that cell a number appears in the formula bar that corresponds with column B in Sheet 2. You can only see that number in the formula bar because there is a drop down with the dates from column A from sheet 2 physically in B1 on the Scorecard, but when I select a date, then the number will change in the formula bar to the corresponding date. What will happen eventually is that when data is entered into the Raw data and a date is selected on the Scorecard all the fields will be able to populate with data for that specific date in the raw data. I hope my attachment attached.

Originally Posted by Triscia

On the scorecard tab, in B1, when you are in that cell a number appears in the formula bar that corresponds with column B in Sheet 2.

No, in the formula bar I see a date that was selected from the dropdown. This is what your file looks like when I open it and haven't touched anything:
Triscia1.JPG

I understand, but what I am trying to do and from what it looks like in one of the demo files I have, where you have the circle in the formula bar, that would actually show 1 because you have that date selected, but if you selected the next date, 10/26/18 a two would show up because it is all based on sheet 2 columns A and B. What will eventually happen is when a date is selected from the drop down it will populate that data from the raw data worksheet. When you have a couple of months, you can just click on the date and the rest of the worksheet in the Scorecard will populate according to the date.

That is exactly what I want to do, how did you do that?

I created an ActiveX combobox.

If you do not see the Developer tab in the ribbon, right click on the ribbon and select Customize the Ribbon. Then check the box for Developer tab.

In the Developer panel, select Insert, and select combobox from the bottom half. Place the combobox over cell B1. Click on Design.

Double click the combobox. Add the code as shown in my example. There are a number of ways to see my code. One is to click on Design then double click the combobox.

Every time the combobox is clicked, the code will insert the corresponding number into B1, which is hidden by the combobox.

Also note that the numbers are listed from 1-50, so the number in B1 is the position of the date. If the numbers change, then the code would have to look up the actual number.