• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Nomination Form

A

Abhijeet

Active Member
Hi

I want to design excel course nomination form

1) Name 2) Surname 3) Process

4) Interests : Vlookup, Index Match,Sumifs,Countifs,Data Validation like me to add more 10 things

5) Which part is user is know in excel

Please tell me how to do this form


userform_23b.gif
 
Hi Abhijeet ,

There is nothing to designing the form ; there is something involved in getting the user to enter data in the form , validate it , and then transfer the entered data into a worksheet ; there is coding involved in adding records , modifying records , deleting records , and searching for records meeting some criteria.

This is a complete application , and you can find the entire code for this in many books on Excel VBA.

One such on the net is here :

http://www.onlinepclearning.com/staff-database-excel-awesome-userform-database/

Surely you cannot expect that someone is going to write all this code for you ?

Narayan
 
I know how to design User Form but vba part or how to pull that data in excel sheet i am struck can you please tell me that
 
Hi Abhijeet ,

That is learning !

Go through the code given in the link , see how it links the userform to the worksheet , and if you have been able to learn well , making the changes to suit your userform should not be a problem.

Narayan
 
Hi

In attach file i have add code but not work can any one please help on this
 

Attachments

  • Book618.xlsm
    17.8 KB · Views: 5
You must log in or register to reply here.
Back
Top