Link to spread sheet using userform

[kalaiselvanv]

hi all,


I am very new to VBA coding features . My company given me database spread sheet in which there are about more than 150000 lines in that sheet.


So i need a user form to retrieve the data from the database spread sheet and edit the features and update the same in the field.


I have uploaded the sample user form design for your reference for coding purpose.


In that if i enter the ID (Top left side) the details of that ID alone should display 31 days as mentioned in the Image i have attached along, afterward i can edit the fields and update.


Thanks


regards

 

[kalaiselvanv]

Re: Required help to link to spread sheet using userform

What do you want the vba code to do?
4000 employees 30 days time sheet with their present and absent and with Overtime details has to updated in the Excel.
So the VBA code has to retrieve the particular employee's time sheet(using search criteria option for employee id's) and display his one month detail from the database spreadsheet (as illustrated below)

​

We need sheet names.
Sheet name is "Master" and excel name is "Timesheet"



Control names like is this data we see in a listbox?
If so what is the name of the listbox
Or is this a whole row of textboxes.
Keep the names as mentioned in the image

What is the control name you plan to click to get the script to do something.



Show us the script you used to load these values into the UserForm
I dont know any script and i havent written any thing.