I have goolged this and seen there are several ways to accomplish this, but I can 't seem to make it work. Not sure if I use VBA or just have the cell value equal the combo box contents.
In my Print Report! worksheet I am using a bunch of vlookups from my DataEntry! worksheet. All of these lookups are currently based off the cell in PrintReport! E3 and they work just fine. But, I would like to use the combo box properties of autocomplete (there will be about 600 entries by the end of the year) to make it easier picking the name. I created a combo box (activeX) and set the properties. I am using quite a bit of Index, Match and vlookups throughout the entire workbook. I have done this all on my own, so I am certain there are better ways, but this is what I know how to do.
Question: How to I set the value in E3 (PrintReport!) to the contents of my combo box?
The combo box will be moved over E3, so the user will only see the combo box.
My workflow will be entering the data into DataEntry! worksheet, then choose from the combo box which will populate the results. Then they will click on EMAIL REPORT which will save as a PDF and email the report (Ok, still working on that part :) )
Thanks for any help!