VBA Macro Debugging

I tried to correct the VBA Code but my VBA is in quite inadequate. The solution also was given here only.
Request you to debug the code.
Auto-Fetch-EEE-5.xlsm
Kanwal_No2Asked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
You seems offended by the Last comment
Not at all, but rereading my comment now I see how you might have gotten that impression. When I suggested you contact him I was trying to be helpful since I thought that he had helped you before and perhaps he could help you better than I could. In any case I'm sorry for the confusion. I don't know much about getting vales from a website but I'll see what I can do.
0
 
Martin LissOlder than dirtCommented:
Please describe the problem.
0
 
Kanwal_No2Author Commented:
It is having a bug in the last line of the following

Public Sub GetNextPAN()
  'strAdd = Range("sheet1!B3").End(xlDown).Offset(1, -1).Address
  strAdd = Range("ListPN").Address
  'UserForm1.TextBox1.Text = Range("sheet1!" & strAdd).Value
UserForm1.TextBox1.Text = Range(strAdd.Text).Value

Open in new window

0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Martin LissOlder than dirtCommented:
OK I think I see the problem. Do you want just one of the "Input Values" to show up in the userform each time or do you want then all to show up at once?
0
 
Kanwal_No2Author Commented:
I could not perceive how all the input values will show up in the userform as in the website accepts only one value at a time.
Basically I could not understand yours query !

If it means that whether I wish all the values to filled up or downloaded in the Sheet then I don't know how the Captcha portion will be handled automatically. But if it can be done that is a quite a remarkable improvement.
0
 
Kanwal_No2Author Commented:
Hi Martin,

Just found yours Article "Using the VBA6 Debugger" and it seems I should have found it much earlier. Thanks a Lot !
It is past 12 in India but I will be finishing it before I go to bed.

Thanks Again. Voted helpful.
0
 
Martin LissOlder than dirtCommented:
Try this workbook. All the changes I made are marked with 'Marty.
Q-28631753.xlsm
0
 
Martin LissOlder than dirtCommented:
Thanks Again. Voted helpful.
You're welcome and thank you for the vote.
0
 
Kanwal_No2Author Commented:
Yes, the file seems to be working,
But there is some scripting error on the page when I Click into the Captcha Box.
Also I could not get the values pasted into my sheet.
I have attached the screenshots
AutoFetch-Script-Error-1.png
AutoFetch-Script-Error-2.png
0
 
Kanwal_No2Author Commented:
AFAICR the earlier solution was given by Jeff Darling. He was marvelous in his approach. I had to abondon then due to script issues on my system which he was not facing. Hope this time it could be finalized.
0
 
Martin LissOlder than dirtCommented:
Maybe you could send a Message to him and ask him to help with this question.
0
 
Kanwal_No2Author Commented:
Hi Martin,

You seems offended by the Last comment. It was just a passing comment. That question was deleted due to my stupidity. It is the same file I have uploaded here for solution again.

Praise of another expert doesn't mean it was anything adverse to you.  Both of you are magicians as per my standard of knowledge so I feel I missed  a "too" in "He was marvelous in his approach". So I request you to please read my comment in a positive spirit.

regards
Kanwal
0
 
Martin LissOlder than dirtCommented:
...there is some scripting error on the page when I Click into the Captcha Box.
I also get a scrpting error and I'm sorry but I don't have any idea how to fix it.

Also I could not get the values pasted into my sheet.
What values are you referring to and where are they supposed to come from?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.