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

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

I did this too. Then tried r-erunning the macro but it didn't work. Goes into
debug mode and highlights this line (ActiveSheet.ShowDataForm).

Matt

"NickHK" wrote:

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

Tried in a new workbook and it actual works. I have come across problems with
other macros. Whereby, ok in new workbook, but if I try and use in an
existing workbook then doesnt work.

"NickHK" wrote:

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

Hi Matthew,

I have the same problem with this one. Did you ever find out how to fix it.
I need to do this in an existing worksheet. I can't use a new one.

"Matthew Balch" wrote:

I did this too. Then tried r-erunning the macro but it didn't work. Goes into
debug mode and highlights this line (ActiveSheet.ShowDataForm).

Matt

"NickHK" wrote:

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