VBA Macro Loop with User Interaction

[sylvesterbetta]

Hi guys,

Will need your assistance in help as I do not have basic VBA programming.

I am trying to create an excel file to fill up the information required by the webpage automatically. Currently I have almost 2000 customer data awaiting to be updated.

Upon login into the webpage, the steps as follows:

1. update customer's data base on the first cell A2 as shown in Sheet 1
2. click on the submit button
3. once the submit button is click, there's a pop up floating bar requesting for the appeared validation code to be entered
4. loop to capture the 2nd customer data from A3

Base on the code I had written it will loop so long as I didn't enter the validation code. I did some read up and realise that excel vba doesn't allow user interaction. I wonder is it true? And also is there any way to over come this problem?

Your help is much appreciated.

 

[EFANYoutube]

Have you tried something like this to capture an answer?

Sub UserInput()
Dim Answer As String
Answer = InputBox("Please tell me your favorite fruit", "Fruit Cake")
ThisWorkbook.Sheets(1).Cells(2, 2).Value = Answer
End Sub

 

[Norie]

Does the validation code need to be entered manually?

Is it some sort of captcha?

 

[sylvesterbetta]

Yup it has to enter manually and the input values changes each time..