Combo box
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 |
Combo box
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 |
Combo box
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 |
Combo box
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 |
Combo box
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 |
Combo box
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 |
All times are GMT +1. The time now is 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com