Excel VBA Combobox Advice

[hayley1988]

Hi,
I have a spreadsheet where sheet 1 shows a list of stores and dates. I then have sheet 2, where I have a created a combobox showing the list of stores from sheet 1. I am trying to write a code in sheet 2, where when I click on each store in my combobox it calls up the date from sheet 1 in a particular cell on sheet 2. Can anyone help me?
Thanks very much

 

[Legacy 287428]

I hope I am asking this in the appropriate place, dont want to start a thread thats already been answered...

I too have two worksheets, (template, and Project Number List), where I have set up the combobox, but I am running into issues I think because I am using both text and numbers. Each project number has been changed to "Text", and the text is also "Text". But, since making it searchable, I can view any of the words when I start typing, but I cannot for the life of me get the numbers to appear when I start searching for them. The cell is linked to the box, and on the project number sheet, I can see the numbers I type pulling up each of the possibilites, but its not showing on the template page.

This is the code I have, for the template sheet:

Private Sub userform_Initilize()
    ComboBox21.ListFillRange = "DropDownList"
    Me.ComboBox21.DropDown
End Sub

I also have the helper columns, which look to be working great, its just not pulling numbers into the combo box.

Thank you, and if I should not have added this post here, I apologize.