Excel Data Entry Form

David Z.

New Member
Joined
Apr 11, 2002
Messages
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?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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...
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top