Hello
I was needing help please on a Excel VBA coding issue.
I have this working on another Excel spreadsheet that i had got help sometime back, but i cant seem to figure out the VB coding. I'm not expert by no means and i was hoping that you guys could guide me to fix it.
1. I have attached a sample of the spreadsheet and what i have is (2) Data Validation list boxes under the Site & GL columns.
2. I would like to use the existing Data Validation list boxes and double click these so that it will Auto Complete the text that i'm typing without having to scroll through the entire list
3. I have a Vlookup that auto populates some coding based on site selection. This works but I thought i would add this to the discussion just to let you know what i'm doing.
4. What i did was copy and paste the code from the spread sheet that is working to the attached and if gives me errors during debug. The first error is
Quote:
|
Set cboTemp = ws.OLEObjects("TempCombo")
|
i appreciate the guidance on getting this issue fixed and eager to learn more about VBA
thanks,