[vba-developement] A question about ComboBox

[Xue S. <app...@gm...>]

Hi everyone,
I need a simple VB demo, but I dont know much about VB. Hope someone can
answer my question. Thanks a lot in advance!

I have a ComboBox object ComboBox1 and some string data in text portion.
What I want to do is input text in ComboBox1, if the input tex has already
existed in the text portion, display relative items, if not add the input to
the text portion.

Here is an example,
In text portion, I have:
apple
apple1
abc
bac

If the first letter I enter is 'a', then it displays a list of
apple
apple1
abc

If the 2nd letter I enter is 'p', it shows
apple
apple1

Now I've already entered 'apple',  if the last letter is 1, no new item
will be added to the text portion, if not,e.g 'apple2', then apple2 is added
to the list.

Thank you very much again!!
Best,
Shan
-- 
Love. Peace. Music.