SWhowing a data form using macro's

  • Thread starter Thread starter Mark Wake
  • Start date Start date
M

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?
 
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.
 
Thanks
-----Original Message-----
ShowDataForm is a bit temperamental. You need to have
Click to expand...
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
Click to expand...
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
Click to expand...
in message news:[email protected]...
 
Back
Top