Hello, I've been searching the web for hours and it seems I just can not locate exactly what I need. I'm hoping someone can assist. I've created a userform that has a listbox which users can add items. I have set the RowSource to the named range in the Excel spreadsheet that will also hold...
hello all,
I am trying to change the selection in a html dropdown menu within a form with vba in order to collect information on the next page.
here is what I have at the moment.
With appIE
' change page
.Document.forms("portfolioView").getElementsByTagName("pv_id") = "2"
.Quit...
I am trying to pull information from a website using a web query in Excel 2003. This part is easy. Now for the difficult part, in order to pull the information I need, I have to manipulate a drop down menu within the page and run my choice. The problem is the site returns the desired...
I am trying to pull information from a website using a web query in Excel 2003. This part is easy. Now for the difficult part, in order to pull the information I need, I have to manipulate a drop down menu within the page and run my choice. The problem is the site returns the desired...
I have a forms combo box /dropdown that I use the index function with to read 150 rows each containing 8 columns from another worksheet. It then shows the selected cells on the worksheet that contains the dropdown.
What I want to be able to do is to use the combo box and when I make the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.