Combo box

  • Thread starter Thread starter Jack Isaacs
  • Start date Start date
J

Jack Isaacs

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?
 
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?
 
I think we have discussed this before Les. The name just sticks out because
Jack Isaacs is a good strong name, I like it.
 
Back
Top