I have created a Forms Combo drop down box. I would like to imput
information into this drop down box. Please Help. Thanks Customer Master.

I'd suggest you use the Data Validation (Combo box) method,
particularly, if you will be adding to the items in the combo box later.

Find an out of the way place in your spreadsheet, say Column Z (Sheet1)
And in Z1 enter your original set of choices, say in row 1 - 4 -- Bob,
Ted, Carol Alice

In the same sheet (at the menu) select Insert, Name Define
In the Names in Workbook box enter:
MyNames
In the Refers to: Box at the bottom - enter:
=OFFSET(Sheet1!$Z$1,0,0,COUNTA(Sheet1!Z:Z),1) << Watch for Sheet name

On the cell (of interest) click data, Validation, as the box comes up
In the Allow Box (Click on the down arrow) and select List
In the Source box enter =MyNames
OK out..

Your ready to roll,

Periodically, you may want to go to Z1:Z? and Sort alphabetically
So that your Combo box does accordingly...

Hope this helps...........

Jim

"customer master" <u22826@uwe wrote in message news:617c5e29f8e0c@uwe:

I have created a Forms Combo drop down box. I would like to imput
information into this drop down box. Please Help. Thanks Customer Master.

as above somewhere else on your worksheet set up a list of your data that you
want to show in your dropdown box.Right click on your dropdown and you will
see a input dialog for your list,and an option to select the number of lines
you want to show in your drop down.I ussually put the cell link in a cell
very close to my list and for later reference i wll put a border or a fil
colour in that cell.When you click the drop down and make a selection this
cell will changeie the first item in your list will result in a 1 the second
a two etc.Now somewhere else on your sheet,ie where you want the output of
the dropdown you need to use an index or choose formula to show the result of
your dropdown.the help topic for the form combo is always difficult to find,i
prefer the form combo box cos it always shows on your form.
--
paul

remove nospam for email addy!



"JimMay" wrote:

I'd suggest you use the Data Validation (Combo box) method,
particularly, if you will be adding to the items in the combo box later.

Find an out of the way place in your spreadsheet, say Column Z (Sheet1)
And in Z1 enter your original set of choices, say in row 1 - 4 -- Bob,
Ted, Carol Alice

In the same sheet (at the menu) select Insert, Name Define
In the Names in Workbook box enter:
MyNames
In the Refers to: Box at the bottom - enter:
=OFFSET(Sheet1!$Z$1,0,0,COUNTA(Sheet1!Z:Z),1) << Watch for Sheet name

On the cell (of interest) click data, Validation, as the box comes up
In the Allow Box (Click on the down arrow) and select List
In the Source box enter =MyNames
OK out..

Your ready to roll,

Periodically, you may want to go to Z1:Z? and Sort alphabetically
So that your Combo box does accordingly...

Hope this helps...........

Jim

"customer master" <u22826@uwe wrote in message news:617c5e29f8e0c@uwe:

I have created a Forms Combo drop down box. I would like to imput
information into this drop down box. Please Help. Thanks Customer Master.

Bob, Ted, Carol Alice ? Boy Jim you sure are dating yourself!! : ) those
were the days eh? larry


"JimMay" wrote:

I'd suggest you use the Data Validation (Combo box) method,
particularly, if you will be adding to the items in the combo box later.

Find an out of the way place in your spreadsheet, say Column Z (Sheet1)
And in Z1 enter your original set of choices, say in row 1 - 4 -- Bob,
Ted, Carol Alice

In the same sheet (at the menu) select Insert, Name Define
In the Names in Workbook box enter:
MyNames
In the Refers to: Box at the bottom - enter:
=OFFSET(Sheet1!$Z$1,0,0,COUNTA(Sheet1!Z:Z),1) << Watch for Sheet name

On the cell (of interest) click data, Validation, as the box comes up
In the Allow Box (Click on the down arrow) and select List
In the Source box enter =MyNames
OK out..

Your ready to roll,

Periodically, you may want to go to Z1:Z? and Sort alphabetically
So that your Combo box does accordingly...

Hope this helps...........

Jim

"customer master" <u22826@uwe wrote in message news:617c5e29f8e0c@uwe:

I have created a Forms Combo drop down box. I would like to imput
information into this drop down box. Please Help. Thanks Customer Master.