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

combo box 2
Combo Box Data Validation - First Entry Blank 2
Combo box in user form 5
Having trouble with combo boxes. 11
Linking Combo Box Values to Access Table 2
User form Text Box & Combo Box. 5
refreshing combo box in form? 1
Selecting from Worksheet to fill combo boxes on User Form 1

Top