Trying to format many Combo boxes at once

[TygerG]

Hello again!

I have a column with 37 rows, that I would like to allow employees to input one of three different choices in. My thought was putting a combo box in each row allowing them to select the item they would like, however I do not want to add all of that code for 37 combo boxes. Does anyone have any ideas for an easier way to do this? I have been searching like crazy and have not found a solution.

Thanks in advance.

[mehmetcik]

I would use data validation.

Select your 37 cells , then select the data tab and then data validation.

Select "Use List" and then enter your list "Apples, Pears, Plums"

You can enhance this by using a simple sheet specific macro.

Right Click on the sheet name at the bottom of your sheet, select "View Code" and paste this code in to the module that opens and close it.

Please Login or Register  to view this content.

[TygerG]

That does work, but when I get out and get back in I get a syntax error. I am sure I am doing something wrong. I do have code on that sheet. What would be the best way to add your code to this?

Please Login or Register  to view this content.

[TygerG]

I finally got it to work. Thank you for the assistance. Rep'd!