Hi All,
I am getting "Run-Time error 13" error when i click on "Open Form" button. Any one can help me how to resolve the issue
Printable View
Hi All,
I am getting "Run-Time error 13" error when i click on "Open Form" button. Any one can help me how to resolve the issue
At a guess, change the XXXXXXXXXXXXX row to column A
Code:'find last data row from database
iRow = ws.Cells(Rows.Count, 1).End(xlUp).Row ' Column A
' iRow = ws.Cells(Rows.Count, 3).End(xlUp).Row XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Cannot see vba code Whats the password ?????
If we can't see the code how do you expect it to get solved ?
Just hack the password :) It's easy.
Under 'userform_activate' you have:
I guess you want this instead.Code:Me.txtSlNo2.Value = ws.Cells(iRow, 1).Value + 1
Changing this value allows the userform to open, and doesn't result in 'Run-Time Error 13'Code:Me.txtSlNo2.Value = ws.Cells(iRow, 1 + 1).Value