9.1K views · 326 reactions | Use Data Validation to create a drop down list. Watch how. | Microsoft Excel | Facebook

Getting Web Page Data into Excel Worksheet Using VBA. 'Below is the VBA Code : Sub test() Dim eRow As Long Dim ele As Object Set sht = Sheets(“Sheet1”) RowCount = 1 sht.Range(“A” & RowCount) = “Title” sht.Range(“B” & RowCount) = “Company” sht.Range(“C” & RowCount) = “Location” sht.Range(“D” & RowCount) = “Description” eRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Set objIE = CreateObject(“InternetExplorer.Application”) myjobtype = InputBox(“Enter type of job eg. sales, administra