Hi,

I have a largish spreadsheet with many column headings (about 30), i know of
the form option as an easy way of changing information or putting new
information in to the spreadsheet, however, what I would really like to do is
for the user to access this form by pressing a button on another sheet, so
that the list criteria are already put in and all she has to do is enter the
information she requires!

Is this possible??

Are you talking about the Data=Form

worksheets("Sheet1").Activate
worksheets("sheet1").ShowDataForm


--
Regards,
Tom Ogilvy

"kirbster1973" wrote in message
...
Hi,

I have a largish spreadsheet with many column headings (about 30), i know
of
the form option as an easy way of changing information or putting new
information in to the spreadsheet, however, what I would really like to do
is
for the user to access this form by pressing a button on another sheet, so
that the list criteria are already put in and all she has to do is enter
the
information she requires!

Is this possible??

Perfect,

Thankyou very much, I really am a novice with Macros, knew it would be simple.

Regards

RIchard

"Tom Ogilvy" wrote:

Are you talking about the Data=Form

worksheets("Sheet1").Activate
worksheets("sheet1").ShowDataForm


--
Regards,
Tom Ogilvy

"kirbster1973" wrote in message
...
Hi,

I have a largish spreadsheet with many column headings (about 30), i know
of
the form option as an easy way of changing information or putting new
information in to the spreadsheet, however, what I would really like to do
is
for the user to access this form by pressing a button on another sheet, so
that the list criteria are already put in and all she has to do is enter
the
information she requires!

Is this possible??