Posts by umakanth79in

I have a VB Macro for emp tracker. I need to convert that into Google sheet. Can anyone help me on that. Attached macro sheet for reference.

Re: Editing existing record in user form

Quote from pike;790575

try,,,

Code

Worksheets("Data").Rows("2:2").Insert Shift:=xlDown
     Worksheets("Data").Cells(2, 1).Value = txtEmpId.Text
    Worksheets("Data").Cells(2, 2).Value = txtEmpName.Text 
    Worksheets("Data").Cells(2, 3).Value = txtContact.Text 
    Worksheets("Data").Cells(2, 4).Value = txtExprience.Text 
    Worksheets("Data").Cells(2, 5).Value = txtSkills.Text 
    Worksheets("Data").Cells(2, 6).Value = txtLocation.Text 
    Worksheets("Data").Cells(2, 7).Value = txtSharedon.Text 
    Worksheets("Data").Cells(2, 8).Value = txtSharedwith.Text 
    Worksheets("Data").Cells(2, 9).Value = txtStatus.Text 
    Worksheets("Data").Cells(2, 10).Value = txtComments.Text

Display More

It's worked fine.

Now I am having one more request. How can I covert this VB Excel macro to Google sheet. Could you please help me on this.

Attached final code sheet for reference

Re: Editing existing record in user form

Quote from pike;790575

try,,,

Code

Worksheets("Data").Rows("2:2").Insert Shift:=xlDown
     Worksheets("Data").Cells(2, 1).Value = txtEmpId.Text
    Worksheets("Data").Cells(2, 2).Value = txtEmpName.Text 
    Worksheets("Data").Cells(2, 3).Value = txtContact.Text 
    Worksheets("Data").Cells(2, 4).Value = txtExprience.Text 
    Worksheets("Data").Cells(2, 5).Value = txtSkills.Text 
    Worksheets("Data").Cells(2, 6).Value = txtLocation.Text 
    Worksheets("Data").Cells(2, 7).Value = txtSharedon.Text 
    Worksheets("Data").Cells(2, 8).Value = txtSharedwith.Text 
    Worksheets("Data").Cells(2, 9).Value = txtStatus.Text 
    Worksheets("Data").Cells(2, 10).Value = txtComments.Text

Display More

It's worked fine.

Now I am having one more request. How can I covert this VB Excel macro to Google sheet. Could you please help me on this

Re: Editing existing record in user form

Thanks a lot. It's working fine now.
I need one more help. Whenever I am inserting a new record it should save as 1st row of data sheet rather than saving at the last.

I have a Employee Tracker form which allow me to Add New record and save it. But I want a code on how to edit the existing record. Attached the macro sheet. Kindly help me to edit and save the record.