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

 

[gibra]

Re: Required help to link to spread sheet using userform

I don't see your UserForm and your image.

 

[kalaiselvanv]

Re: Required help to link to spread sheet using userform

I don't see your UserForm and your image.

Thanks for your response, please find the below image

 

[My Aswer Is This]

Re: Required help to link to spread sheet using userform

We will need some details about what you want help with.

 

[gibra]

Re: Required help to link to spread sheet using userform

What component do you use as a grid, in your image?

 

[kalaiselvanv]

Re: Required help to link to spread sheet using userform

We will need some details about what you want help with.

well basically i need a VBA coding embedded in the form.
What exactly detail you require let me know i will revert back.

 

[My Aswer Is This]

Re: Required help to link to spread sheet using userform

What do you want the vba code to do?

We need sheet names.

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.
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

 

[kalaiselvanv]

Re: Required help to link to spread sheet using userform

Actually iam not sure about this.

 

[kalaiselvanv]

Re: Required help to link to spread sheet using userform

What component do you use as a grid, in your image?

Actually iam not sure about this.

 

[gibra]

Re: Required help to link to spread sheet using userform

Actually iam not sure about this.

It seems you do not have any knowledge of VBAs and macros, if so you have to start to familiarize yourself with creating a userform for data management.
You could start from this guides:

How to add a UserForm to aid data entry in Excel - TechRepublic
https://www.techrepublic.com/article/pro-tip-add-a-userform-to-aid-data-entry-in-excel/

To load filtered data by ID, you could use a ListBox (as grid):
Listboxes on userforms with Excel VBA macros
http://sitestory.dk/excel_vba/listboxes.htm