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
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
'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
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
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.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'Me.txtSlNo2.Value = ws.Cells(iRow, 1 + 1).Value
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3