List/combo box/form? Want data entered to fill excel sheet

S

Sarahmtz

Hello,

I am stuck on what to do here. I am not familiar with programming VBS. I
created a DB in Access, but we now want it to be in Excel only.
I want to make a form or combo box that fills my excel worksheet with the
data entry, or just a combo box in the worksheet that is populated by a
specific list.
Dont know where to start- any advice or suggestions?
 
C

Corey

How much Data needs to be entered?
Is the Data in the WorkBook?
Is the Data on the Same Sheet or Various Sheets?


A Userform can do any of the above, with Textboxes, Comboboxes and ListBoxes
filling Cells in Sheets.

Corey....
 
S

Sarahmtz

Thanks for your help Corey!

1. I have about 26 columns, and we need to eventually enter about 300-500
rows.
In the workbook I have about 10 sheets, but only three of them have data
entry. Each of those 3 sheets would use a different form.
 
S

Sarahmtz

Hey

The data I want to fill one of the combo boxes is from a separate sheet- MD
names-not a data entry sheet.

Thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Add additional information to excel form after original data entry 0
Combo box 0
Combo or list box 0
combo box 2
Combo boxes in excel 6
How do I clear a form? 0
list or combo box 0

Top