Hello All

I am using excel 2000. I am creating a simple data-input sheet, where the
user will be entering name, addresses, etc etc. - with each field in its own
column. I would like a column for "Job Title" where the user must choose
from a pre-determined value - e.g. Receptionist, Secretary, Manager, etc
etc.

I have tried creating a combobox from the Control Toolbox, but can't seem to
work out how to get the data value options (Receptionist, Secretary,
Manager, etc ) in, and also how to get the combobox to fill the cell (so
that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in the
Job Title column? That doesn't seem right - after all I do not know how many
rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem to get
it.

Hope someone can help.

Many thanks
Les

Use data validation, it is simpler. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jack Isaacs" wrote in message
...
Hello All

I am using excel 2000. I am creating a simple data-input sheet, where the
user will be entering name, addresses, etc etc. - with each field in its
own column. I would like a column for "Job Title" where the user must
choose from a pre-determined value - e.g. Receptionist, Secretary,
Manager, etc etc.

I have tried creating a combobox from the Control Toolbox, but can't seem
to work out how to get the data value options (Receptionist, Secretary,
Manager, etc ) in, and also how to get the combobox to fill the cell (so
that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in the
Job Title column? That doesn't seem right - after all I do not know how
many rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem to
get it.

Hope someone can help.

Many thanks
Les

Bob

Thanks a million - as you say that is much simpler!

Thanks again
Les

"Bob Phillips" wrote in message
...
Use data validation, it is simpler. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jack Isaacs" wrote in message
...
Hello All

I am using excel 2000. I am creating a simple data-input sheet, where the
user will be entering name, addresses, etc etc. - with each field in its
own column. I would like a column for "Job Title" where the user must
choose from a pre-determined value - e.g. Receptionist, Secretary,
Manager, etc etc.

I have tried creating a combobox from the Control Toolbox, but can't seem
to work out how to get the data value options (Receptionist, Secretary,
Manager, etc ) in, and also how to get the combobox to fill the cell (so
that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in
the Job Title column? That doesn't seem right - after all I do not know
how many rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem to
get it.

Hope someone can help.

Many thanks
Les

BTW, how come Jack Isaacs signs himself as Les. Are you trying to confuse us
poor oldies?

"Jack Isaacs" wrote in message
...
Bob

Thanks a million - as you say that is much simpler!

Thanks again
Les

"Bob Phillips" wrote in message
...
Use data validation, it is simpler. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jack Isaacs" wrote in message
...
Hello All

I am using excel 2000. I am creating a simple data-input sheet, where
the user will be entering name, addresses, etc etc. - with each field in
its own column. I would like a column for "Job Title" where the user
must choose from a pre-determined value - e.g. Receptionist, Secretary,
Manager, etc etc.

I have tried creating a combobox from the Control Toolbox, but can't
seem to work out how to get the data value options (Receptionist,
Secretary, Manager, etc ) in, and also how to get the combobox to fill
the cell (so that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in
the Job Title column? That doesn't seem right - after all I do not know
how many rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem to
get it.

Hope someone can help.

Many thanks
Les

Sorry Bob - I'm Les, my 14 year old son is Jack, and he had set up the
newsgroup account. Now so have I!
Thanks
Les (!)
BTW - did you see my further post about validating times?


"Bob Phillips" wrote in message
...
BTW, how come Jack Isaacs signs himself as Les. Are you trying to confuse
us poor oldies?

"Jack Isaacs" wrote in message
...
Bob

Thanks a million - as you say that is much simpler!

Thanks again
Les

"Bob Phillips" wrote in message
...
Use data validation, it is simpler. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jack Isaacs" wrote in message
...
Hello All

I am using excel 2000. I am creating a simple data-input sheet, where
the user will be entering name, addresses, etc etc. - with each field
in its own column. I would like a column for "Job Title" where the user
must choose from a pre-determined value - e.g. Receptionist, Secretary,
Manager, etc etc.

I have tried creating a combobox from the Control Toolbox, but can't
seem to work out how to get the data value options (Receptionist,
Secretary, Manager, etc ) in, and also how to get the combobox to fill
the cell (so that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in
the Job Title column? That doesn't seem right - after all I do not know
how many rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem to
get it.

Hope someone can help.

Many thanks
Les

I think we have discussed this before Les. The name just sticks out because
Jack Isaacs is a good strong name, I like it.

"Les Isaacs" wrote in message
...
Sorry Bob - I'm Les, my 14 year old son is Jack, and he had set up the
newsgroup account. Now so have I!
Thanks
Les (!)
BTW - did you see my further post about validating times?


"Bob Phillips" wrote in message
...
BTW, how come Jack Isaacs signs himself as Les. Are you trying to confuse
us poor oldies?

"Jack Isaacs" wrote in message
...
Bob

Thanks a million - as you say that is much simpler!

Thanks again
Les

"Bob Phillips" wrote in message
...
Use data validation, it is simpler. See
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jack Isaacs" wrote in message
...
Hello All

I am using excel 2000. I am creating a simple data-input sheet, where
the user will be entering name, addresses, etc etc. - with each field
in its own column. I would like a column for "Job Title" where the
user must choose from a pre-determined value - e.g. Receptionist,
Secretary, Manager, etc etc.

I have tried creating a combobox from the Control Toolbox, but can't
seem to work out how to get the data value options (Receptionist,
Secretary, Manager, etc ) in, and also how to get the combobox to fill
the cell (so that it looks like it IS the cell).

Also, am I going to have to create seperate comboboxes for each row in
the Job Title column? That doesn't seem right - after all I do not
know how many rows the user will complete.

I'm sure there must be a simple way of doing this, but I cannot seem
to get it.

Hope someone can help.

Many thanks
Les