Matt,
I just recorded a macro of this action and it gave:

ActiveSheet.ShowDataForm

NickHK

"Matthew Balch" ...
The tool in excel under data forms is a very useful tool. But I would
like
this function to be used by other people. So how do I go about creating a
macro that will open up this data form for the selected data range I have
in
mind.

Help appreciated as always.

Regards
Matt