Link from field to drop down list

  • Thread starter Thread starter Kassie Alcorn
  • Start date Start date
K

Kassie Alcorn

Good Morning All,

Currently I'm trying to link a field in Microsoft Excel to a drop down list
so it automatically updates as you begin to type text. This is a suburb
field if that gives you more of an idea of what Im trying to achieve.

Thanks
 
Hi, Kassie. Excel doesn't do this with a dropdown list. Only Access does. I
don't even think it can be coded to do so.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Kassie Alcorn said:
I'm trying to link a field in Microsoft Excel to a drop down list
so it automatically updates as you begin to type text.
Click to expand...

In the above 'it' is ambiguous. If 'it' is the Excel cell (field), its
'linked cell' property will do the trick. If 'it' is the combobox
(dropdown), the 'linked cell' property will only cause the combo to be
updated once editing has finished, not as you type. There's a good
reason for this: there's no way of knowing in advance whether the
input will have 'special' meaning e.g. it could be a cell formula, in
which case you'd presumably want to show its value rather than the
formula itself in the combo.

Jamie.

--
 
Back
Top