Excel Data Entry Form

David Z. · Apr 12th, 2002, 03:45 PM

I have an Excel data entry form and after I save the data I would like the form to automatically refresh to accept new data. Is there anyway to do this without closing the worksheet and then re-opening?

daleyman · Apr 13th, 2002, 05:19 PM

i don't understand, do you already have code that opens the data entry form when you open the workbook?

If so, there is no similar event for AfterSave, as it were, but you could add a button to the page to allow the data entry form to open up when you click it...

Yogi Anand · Apr 13th, 2002, 05:25 PM

I believe David Z is referring to DATA|FORM a virtual Data Entry Form that is generated within the worksheet wihout any VBA code. The form is virtual and volatile. After you are done with entering the data the form is gone. You have to ask for the DATA|FORM to show up every time you want to use it!

daleyman · Apr 13th, 2002, 05:28 PM

understood, but question implies that this form is already triggered OnOpen.

This form can be triggered using VBA, if required, and this trigger can be attached to a button, eg...

sheets("sheet1").Columns("A:C").Select
ActiveSheet.ShowDataForm

Yogi Anand · Apr 13th, 2002, 05:34 PM

Good thinking daleyman ...
I may have misjudged David Z's intent.
THANKS!

Apr 13th, 2002, 05:19 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	i don't understand, do you already have code that opens the data entry form when you open the workbook? If so, there is no similar event for AfterSave, as it were, but you could add a button to the page to allow the data entry form to open up when you click it... __________________ <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;">*DALEY :P**</td></table>

Apr 13th, 2002, 05:25 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	I believe David Z is referring to DATA\|FORM a virtual Data Entry Form that is generated within the worksheet wihout any VBA code. The form is virtual and volatile. After you are done with entering the data the form is gone. You have to ask for the DATA\|FORM to show up every time you want to use it! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Apr 13th, 2002, 05:28 PM	#4
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	understood, but question implies that this form is already triggered OnOpen. This form can be triggered using VBA, if required, and this trigger can be attached to a button, eg... sheets("sheet1").Columns("A:C").Select ActiveSheet.ShowDataForm __________________ <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;">*DALEY :P**</td></table>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 03:45 PM	#1
David Z. New Member Join Date: Apr 2002 Posts: 1	I have an Excel data entry form and after I save the data I would like the form to automatically refresh to accept new data. Is there anyway to do this without closing the worksheet and then re-opening?

Apr 13th, 2002, 05:34 PM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Good thinking daleyman ... I may have misjudged David Z's intent. THANKS!