How easy is it to have a cell that has a drop down box in it containing two
values. (e.g. yes / no).

If one value is selected (e.g. yes), the five cells below that cell are auto
populated with a value, if the other value is selected they are blanked so
free text can be added.

I assume this will mean I have to delve into the realm of Macro writing (I
have programmed in VB6 so should be able to get on with syntax / object
model etc) but if I don't then that will be a bonus.

Thanks

David