Data Entry Form Using VBA

[azad092]

hi
dear members good morning
I have a data entry sheet. I i am using the data entry form which is designed by default in excel. you can see in the image
But this form cannot be modified as per requirement. I want to design such a data entry form with some specific features.
1 I want that when I clink in Date textbox the date calendar should be displayed.
2 The data entry form should have the post data and search data button.
3 The data should be posted in data entry sheet in descending order. Means that every new entry that I want to enter should be posted in the first row of the data entry sheet
If someone of you can help me in this issue... please guide me thanks

 

[dmt32]

Hi,
what you are asking for is quite involved however, in past John Walkenbach created an enhanced data form as an alternative to the built-in form & may do some of the things you required.

The form is / was available to download for free (not sure if link still works) J-Walk Enhanced DataForm

Application is written entirely with MS VBA & in past, you could be a fee to author to access the code & modify form if needed but not sure if this is still an option.

Dave

 

[azad092]

Hi,
what you are asking for is quite involved however, in past John Walkenbach created an enhanced data form as an alternative to the built-in form & may do some of the things you required.

The form is / was available to download for free (not sure if link still works) J-Walk Enhanced DataForm

Application is written entirely with MS VBA & in past, you could be a fee to author to access the code & modify form if needed but not sure if this is still an option.

Dave

ok thanks.......... let me check

 

[azad092]

hi
dear members good morning
I have a data entry sheet. I i am using the data entry form which is designed by default in excel. you can see in the image
But this form cannot be modified as per requirement. I want to design such a data entry form with some specific features.
1 I want that when I clink in Date textbox the date calendar should be displayed.
2 The data entry form should have the post data and search data button.
3 The data should be posted in data entry sheet in descending order. Means that every new entry that I want to enter should be posted in the first row of the data entry sheet
If someone of you can help me in this issue... please guide me thanks
View attachment 54960

still no solution received by anyone....
I am waiting for best solution