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

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?

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

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....

"Sarahmtz" wrote in message
...
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?

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

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.

"Corey" wrote:

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....

"Sarahmtz" wrote in message
...
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?

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

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

"Corey" wrote:

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....

"Sarahmtz" wrote in message
...
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?