In the Control Toolbar there are ActiveX controls that you can use. I would not suggest using very many of these directly in your spreadsheet, although what many people do, is create UserForms which are displayed and have the combo box listed on the UserForm.
If you are attempting to speed data entry, then ALT+Down arrow key in a column will provide a combo box of previously used entries. A1 = Dog A2 = Cat A3 = Rabbit A4 - ALT+Down Arrow, will develop a Combo box which will list Cat, Dog, Rabbit. You can then down arrow to "Dog" and press Enter to enter Dog in A4. Dawn Crosier Application Specialist Microsoft MVP "Education Lasts a Lifetime" -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Sent: Sunday, May 01, 2005 11:19 AM To: [email protected] Subject: [ms_access] Combo Box: Access to Excel For Access, I often use a "combo box" to make a drop-down list of entry choices. Things like "yes, no, up, down, always, never." In Excel, I know there is a way to make a similar drop-down list, but I cannot seem to find out how. Does anyone know? Thank you, Bob Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
