SWhowing a data form using macro's

[Mark Wake]

I have a series of spredsheets that are linked, with all
the data coming from the first sheet. Rather than go cell
by cell to enter the data, I have set up a data form.
Ihave tried to write a macro that opens the data form at
the click of a buuton but it keeps stopping.

Code so far is:-

Sheets("Registration").Select
Range("B5:Y750").Select
Range("B5:Y750").Activate
Sheets("Registration").ShowDataForm

It stops at the last line. IS the syntax incorrect?

 

[John Green]

ShowDataForm is a bit temperamental. You need to have your data range start in A1, A2, B1 or B2 except when you give it the name of
Database. In other words, use Insert|Name|Define and apply the name Database to your data range. Also, it is no longer necessary to
select a cell in the data range before showing the form.

 

[Guest]

Thanks

-----Original Message-----
ShowDataForm is a bit temperamental. You need to have

your data range start in A1, A2, B1 or B2 except when you
give it the name of

Database. In other words, use Insert|Name|Define and

apply the name Database to your data range. Also, it is no
longer necessary to

select a cell in the data range before showing the form.

--

John Green - Excel MVP
Sydney
Australia


"Mark Wake" <[email protected]> wrote

in message news:[email protected]...