In some Databases I design, I keep a "special row" at the top of my sheet,
in Row 1, give it a rangename, and copy it below whenever, wherever I
want.....I set the height of the row at .1 so it will not
show.......dropdowns can be created using the Data Validation List
options.....

hth
Vaya con Dios,
Chuck, CABGx3


"mr. App" wrote in message
...
Hi,

I need a special excel sheet that each row has several controls in it, for
example -
Column A is a dropdown which each item has text and value.
Column B,C,D are simple text boxes which require some text as data.
Column E is also a dropdown same as column A.
The question is - first, how do I create such a dropdown ( I mean, with
text
and value). And second - how do I set such a row to be somethink like a
"Known Row" so I will be able to add such row to the sheet as many times
as
I want.

Thanks.