software

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
quot;Known Rowquot; so I will be able to add such row to the sheet as many times as
I want.

Thanks.
In some Databases I design, I keep a quot;special rowquot; 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 gt; Validation gt; List
options.....

hth
Vaya con Dios,
Chuck, CABGx3quot;mr. Appquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I need a special excel sheet that each row has several controls in it, for
gt; example -
gt; Column A is a dropdown which each item has text and value.
gt; Column B,C,D are simple text boxes which require some text as data.
gt; Column E is also a dropdown same as column A.
gt; The question is - first, how do I create such a dropdown ( I mean, with
text
gt; and value). And second - how do I set such a row to be somethink like a
gt; quot;Known Rowquot; so I will be able to add such row to the sheet as many times
as
gt; I want.
gt;
gt; Thanks.
gt;
gt;
CLR, can you please shed some light on the special row issue? how do you
give it a rangename? how do you copy it to other places?

Thanks!

quot;CLRquot; gt; wrote in message
...
gt; In some Databases I design, I keep a quot;special rowquot; at the top of my sheet,
gt; in Row 1, give it a rangename, and copy it below whenever, wherever I
gt; want.....I set the height of the row at .1 so it will not
gt; show.......dropdowns can be created using the Data gt; Validation gt; List
gt; options.....
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;mr. Appquot; gt; wrote in message
gt; ...
gt;gt; Hi,
gt;gt;
gt;gt; I need a special excel sheet that each row has several controls in it,
gt;gt; for
gt;gt; example -
gt;gt; Column A is a dropdown which each item has text and value.
gt;gt; Column B,C,D are simple text boxes which require some text as data.
gt;gt; Column E is also a dropdown same as column A.
gt;gt; The question is - first, how do I create such a dropdown ( I mean, with
gt; text
gt;gt; and value). And second - how do I set such a row to be somethink like a
gt;gt; quot;Known Rowquot; so I will be able to add such row to the sheet as many times
gt; as
gt;gt; I want.
gt;gt;
gt;gt; Thanks.
gt;gt;
gt;gt;
gt;
gt;
Highlight the cells of the row you wish to duplicate, then INsert gt; Name gt;
Define, and type a name in the small window....I used RowFormat as the name
of my range for the macro below.....
Then I set the RowHeight of that row to .1 so it doesn't show.....
Then I have a Freeze line above row 8 so I can keep titles and macro buttons
there to be seen all the time.
Then, whenever I want to enter a new row at the bottom of my database, I run
this macro, and it inserts the special row in the next available row below
my data and takes the screen there for data entry....

Sub RowFormat()
Application.Goto Reference:=quot;RowFormatquot;
Selection.Copy
Application.Goto Reference:=quot;R8C1quot;
Selection.End(xlDown).Offset(1, 0).Select
ActiveSheet.Paste
End Sub

......or, to put it someplace else, you can do F5 gt; RowFormat gt; Edit Copy gt;
then select the cell in column A where you wish to insert the special row,
and do Edit gt; Paste......hth
Vaya con Dios,
Chuck, CABGx3
quot;mr. Appquot; gt; wrote in message
...
gt; CLR, can you please shed some light on the special row issue? how do you
gt; give it a rangename? how do you copy it to other places?
gt;
gt; Thanks!
gt;
gt; quot;CLRquot; gt; wrote in message
gt; ...
gt; gt; In some Databases I design, I keep a quot;special rowquot; at the top of my
sheet,
gt; gt; in Row 1, give it a rangename, and copy it below whenever, wherever I
gt; gt; want.....I set the height of the row at .1 so it will not
gt; gt; show.......dropdowns can be created using the Data gt; Validation gt; List
gt; gt; options.....
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;mr. Appquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hi,
gt; gt;gt;
gt; gt;gt; I need a special excel sheet that each row has several controls in it,
gt; gt;gt; for
gt; gt;gt; example -
gt; gt;gt; Column A is a dropdown which each item has text and value.
gt; gt;gt; Column B,C,D are simple text boxes which require some text as data.
gt; gt;gt; Column E is also a dropdown same as column A.
gt; gt;gt; The question is - first, how do I create such a dropdown ( I mean, with
gt; gt; text
gt; gt;gt; and value). And second - how do I set such a row to be somethink like a
gt; gt;gt; quot;Known Rowquot; so I will be able to add such row to the sheet as many
times
gt; gt; as
gt; gt;gt; I want.
gt; gt;gt;
gt; gt;gt; Thanks.
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;