Connect Excel list to DBCombo in VB forms

How connect a database list stored in excel worksheet to DBCombo control in VB form (Excel 97)?
Who is Participating?
sduckettConnect With a Mentor Commented:
1. Put a data control on your form
2. For that controls Connect property, choose 'Excel 8.0'.
3. Property, DatabaseName = Your XL database file.
4. Property, RecordSource = The sheet in your xls
5. For your DBCombo, RowSource = Your Data control
6. For your DBCombo, ListField = Field on your XL sheet
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.