ExcelBanter - Auto fil in

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Auto fil in (https://www.excelbanter.com/excel-discussion-misc-queries/154657-auto-fil.html)

How can I get a cell to enter data from a list when typing the first letters.
I can get it to fill from a pulldown with no problem, but clairvoiance would
be great
--
Regards,

Art

You can use a combobox from the control toolbox toolbar

--

Regards,

Peo Sjoblom

"hddude52" wrote in message
...
How can I get a cell to enter data from a list when typing the first
letters.
I can get it to fill from a pulldown with no problem, but clairvoiance
would
be great
--
Regards,

Art

Thanks Peo but I'm not familar with VB. But with combobox, it seemed that I
would have to draw a result cell whever I wanted a value, I want it in a
worksheet cell.

Thanks.
--
Regards,

Art

"Peo Sjoblom" wrote:

You can use a combobox from the control toolbox toolbar

--

Regards,

Peo Sjoblom

"hddude52" wrote in message
...
How can I get a cell to enter data from a list when typing the first
letters.
I can get it to fill from a pulldown with no problem, but clairvoiance
would
be great
--
Regards,

Art