Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2021, 04:06 PM
Bo_Knows_04 Bo_Knows_04 is offline Excel Vlookup & Data Validation list box with AutoComplete Windows 7 64bit Excel Vlookup & Data Validation list box with AutoComplete Office 2016
Novice
Excel Vlookup & Data Validation list box with AutoComplete
 
Join Date: Jan 2018
Posts: 4
Bo_Knows_04 is on a distinguished road
Question Excel Vlookup & Data Validation list box with AutoComplete

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,
Attached Files
File Type: xls Req.xls (246.0 KB, 1 views)
Reply With Quote
  #2  
Old 02-23-2021, 01:32 PM
NoSparks NoSparks is offline Excel Vlookup & Data Validation list box with AutoComplete Windows 10 Excel Vlookup & Data Validation list box with AutoComplete Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 805
NoSparks is a jewel in the roughNoSparks is a jewel in the roughNoSparks is a jewel in the rough
Default

Did you add the combo box ?
Excel Data Validation Combo box using Named Ranges
Reply With Quote
  #3  
Old 02-24-2021, 09:10 PM
trevorc trevorc is offline Excel Vlookup & Data Validation list box with AutoComplete Windows 7 32bit Excel Vlookup & Data Validation list box with AutoComplete Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 145
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

The combo box may have a different name.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Vlookup & Data Validation list box with AutoComplete Alternative to a data validation list? gebobs Excel 5 08-01-2016 12:28 PM
Excel Vlookup & Data Validation list box with AutoComplete Data Validation - List Webbn111 Excel 9 03-09-2016 04:30 PM
Excel Vlookup & Data Validation list box with AutoComplete Trying to get Data into Validation List according to Client Name and Document Type Maoz Excel 5 01-24-2016 01:17 AM
Excel Vlookup & Data Validation list box with AutoComplete Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM
Excel Vlookup & Data Validation list box with AutoComplete Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft