Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

auto complete typing in an excel data validation list

0

Hello,

We use this code in formulas:

=OFFSET(CustomersList!$BB$3;1;;COUNTA(CustomersList!$BB$4:$BB$20)-1;1)

for filling in the validation list data on G2

But I can not get the auto complete to run

What are we doing wrong?

If there's any other way for reaching our goal

I like to hear, But i don't wanna use a combobox because

Then i have to rewrite a lot of code again.

excelmacros-vba
MS Office Version: 2017
posted by: GhostofWanted (rep: 46) on Mon Nov 30, 2020 at 1:12 pm
Answer
Discuss

Discussion

Ghost, you are really livening up this forum, Ghost. Much appreciated! But we mustn't convert it into a blog. Please help.
The point of a Q&A forum is to provide answers to questions. Many of our visitors come to learn. Of this question, for example, they can learn nothing, regardless of how smart the answer eventually might be. That is because it isn't self-contained. It's part of a correspondence which becomes more exclusive the longer it continues. In the end that isn't good for you because you are limited to the knowledge of only one partner who knows what you are talking about, and it's not good for the forum because everybody else is excluded.
Variatus (rep: 4889) Nov 30, '20 at 8:32 pm
Hello Variatus,
O, sorry
I guess you have a point somewhere.
GhostofWanted (rep: 46) Nov 30, '20 at 9:56 pm
Fair point Variatus. I'm guitly of "getting dragged into the weeds" of a given workbook in order to helpGhost but anyone arriving later would need to go through all the linked correspondence to understand the context of the Q&A.
John_Ru (rep: 6142) Dec 1, '20 at 6:54 am
Add to Discussion

Answers

0
Selected Answer

I think the correct approach is to use a ComboBox (over G2) and have it linked to G2 (with your validation formula and macros as they are now and triggering your existing WorksheetChange macros). I don't have time to check that tonight but please see How To Autocomplete When Typing In Excel Drop Down List?

posted by: John_Ru (rep: 6142) on Mon Nov 30, 2020 at 1:25 pm
Discuss

Discussion

okay, thanks
I'll see where we end :)
GhostofWanted (rep: 46) Nov 30, '20 at 1:34 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login