Is there a method to display a selected row in
ShowDataForm?

The first row in my worksheet contains the field labels,
the remaining rows data. I would like the user to select
a cell in a data row, then invoke a macro. The macro
will obtain the current selection, invoke ShowDataForm
and set the ShowDataForm contents to the user's row
selection. This macro should work with other worksheets
also.

If the ShowDataForm contents cannot be set, are there
other Form editors that can be used?

thanks.

Hi Alan

John Walkenbach his much better Dataform
http://j-walk.com/ss/dataform/index.htm

See this
http://j-walk.com/ss/dataform/features.htm
to see the differents between the Excel dataform and John's one

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Alan" wrote in message ...
Is there a method to display a selected row in
ShowDataForm?

The first row in my worksheet contains the field labels,
the remaining rows data. I would like the user to select
a cell in a data row, then invoke a macro. The macro
will obtain the current selection, invoke ShowDataForm
and set the ShowDataForm contents to the user's row
selection. This macro should work with other worksheets
also.

If the ShowDataForm contents cannot be set, are there
other Form editors that can be used?

thanks.

thanks.

-----Original Message-----
Hi Alan

John Walkenbach his much better Dataform
http://j-walk.com/ss/dataform/index.htm

See this
http://j-walk.com/ss/dataform/features.htm
to see the differents between the Excel dataform and
John's one

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Alan" wrote in
message ...
Is there a method to display a selected row in
ShowDataForm?

The first row in my worksheet contains the field
labels,
the remaining rows data. I would like the user to
select
a cell in a data row, then invoke a macro. The macro
will obtain the current selection, invoke ShowDataForm
and set the ShowDataForm contents to the user's row
selection. This macro should work with other worksheets
also.

If the ShowDataForm contents cannot be set, are there
other Form editors that can be used?

thanks.



.