Forum Discussion
Required help to link to spread sheet using userform
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
- That is incorrect, you can use the Find buttons to find an existing record and edit it and use the criteria button to actaully search in the data. The Criteria also accepts wildcards.
6 Replies
- Have you tried the ancient Data, Form feature (available by modifying your QAT and selecting from the Commands not in the ribbon) short-cut key: alt+d, o
Thanks for the response yes i saw that data form features, but it create new data. but for me i have already have more than 150000 lines in a sheet(which company provides) so i have to retrieve the data of a particular employee and update his details and save.
- That is incorrect, you can use the Find buttons to find an existing record and edit it and use the criteria button to actaully search in the data. The Criteria also accepts wildcards.
- Duplicate post, also poosted here: https://www.mrexcel.com/forum/excel-questions/1049314-required-help-link-spread-sheet-using-userform.html
