Creating Drop Down List

**jhelliar** · 12-30-2007, 09:39 AM

I am trying to write produce a simple spredsheet for writing school reports. In column G of my spreadsheet the main comment is entered and this can be a maximum of 400 characters. Is there any way of limiting the amount that can be put into a cell or if not is there a simple macro I could use to make the cell go red if the length is over 400?

Jack

**VBA Noob** · 12-30-2007, 09:45 AM

Try

Data > Validaion > Setting Tab > allow (dropdown) > Text length > set as required

VBA Noob

**royUK** · 12-30-2007, 09:46 AM

You can use Data Validation to specify a inimum & a maximum text length. You can also add an error message.

From the Data menu select validation. In the settings tab find Text length in the allow drop down.

**jhelliar** · 12-30-2007, 09:53 AM

I want to create a drop down list in cell B3 which means that you can only type the numbers 1,2,3,4 or 5. Is there an easy way to do this and to copy the list for more cells in the column? I also need to have another list for F3 which can have A*,A,B,C,D,E. Can I use the came method to do this?

Jack