VBA Macro Debugging

Please describe the problem.

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

Select allOpen in new window

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?

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.

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.

Try this workbook. All the changes I made are marked with 'Marty.
Q-28631753.xlsm

Thanks Again. Voted helpful.

You're welcome and thank you for the vote.

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

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.

Maybe you could send a Message to him and ask him to help with this question.

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

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