code or macro that would save data then clear form

's Computer Specifications

I have a form built that I would like to ba able to create a database of
saved data from before excuting my clear reset macro.
Example would be:
Transfer data from my form, save on the next available row in another
worksheet then clear form. Any ideas?

's Computer Specifications

I'd start on Debra Dalgleish's site:
http://contextures.com/xlForm02.html

and you didn't ask for this:
http://contextures.com/xlForm03.html

Japs wrote:
>
> I have a form built that I would like to ba able to create a database of
> saved data from before excuting my clear reset macro.
> Example would be:
> Transfer data from my form, save on the next available row in another
> worksheet then clear form. Any ideas?

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help! How does one clear a form with code?	=?Utf-8?B?TmFuY3k=?=	Microsoft Access Forms	4	16th Feb 2007 04:29 PM
Creating a graph with existing data...clear data after save	=?Utf-8?B?Q2FtIE5lZXNvbg==?=	Microsoft Excel Programming	3	15th Jun 2006 06:37 PM
macro to save wookbook add 1 to to a ref No. clear cells	=?Utf-8?B?UXVpbm5EZXh0ZXI=?=	Microsoft Excel Programming	1	28th Sep 2005 01:40 PM
Clear macro before save	Jon	Microsoft Excel Misc	6	17th May 2004 04:43 PM
save form data in code	Craig Buchanan	Microsoft Access Form Coding	0	5th May 2004 09:08 PM