The list is a Data Validation list . . it is on the current workbook. . .
..The user would click on an action item from the list . . .The list does not
consists of entries from Row 1, the list is part of Row 1, it would be in
Column L . . .please let me know if you require more information . . .

"Otto Moehrbach" wrote:

Martha
There is no "VBA command" to do what you want. It's just a matter of
writing a VBA macro that includes the instructions to do what you want.
You say you have "that list". What list? Where is it? In what form is the
list? Is it a Data Validation list?
You say "when a user choses an action from that list". What does he do when
he "chooses an action from that list"? Exactly what does he do? Does he
click on an item in the "list"?
You say "If User chooses "Sample" . .from the list in Row 1". Do you mean
that the "list" consists of the entries in Row 1? Like headers perhaps?
To insert a number (any number) of rows as a function of the selection made
is easy to do. But the devil is in the details. Please post back with more
detail. HTH Otto
"MarthaSue" wrote in message
...
I am looking for a VBA Command for the following situation . . . .

it possible that when a user choses an action from that list that rows
can be
inserted and new data entered . . If User chooses "Sample" . .from the
list
in Row 1 . . . can i create a function that will insert one row when
Sample
is chosen (Insert Row 2) . . but if User chooses Inspect . . .from the
list
in Row 1 . . .can the "function" insert three row (Insert Row 2, 3, & 4)
. .
.Currently Row 1 contains several columns of data describing a particular
location and the work that has been currently completed on the site .
.one
location can be used once or can be used multiple times. . . . each
location
is unique . .none the same . . .i want to be able to not have to write
all
the info. over and over again . . . Row 2 would contain several columns
of
information for a new location . . .i would like to create a function
that
would allow the user to enter more data on location in Row 1 if need be .
.dependant on the work that might have to be completed . . .Sample,
Inspect,
Mix . . . Is this possible . . please let me know if you require more
information . . Once again i appreciate your time . .

Please let me know if you require more information .. . i am a rookie when
it come to this sort of thing . . . thanks for your time . . . .