View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Disco[_2_] Disco[_2_] is offline
external usenet poster
 
Posts: 2
Default Using Combo boxes in excel

Finally worked it out myself.
Thanks
-----Original Message-----
Hi ,
I am trying to add combo boxes to an excel spreadsheet

and
although I have had success in creating the combo box (
using the forms toolbar )and referencing the correct data
I do still have a problem.
When I create a combo box on a form in Access I can type
characters into it and it will automatically jump to the
relevant data as I type.
I cannot seem to emulate this in excel as I cannot even
type into the combo box.
I have tried using a combo box from the control toolbox
but I can't work out how to reference the data ( I

presume
I do this with code ).
Can anybody help ?

Thanks in advance
.