Hello, Ive seen a few questions about adding controls at runtime but Im afraid I must be missing a few concepts. I have tried to adapt some code but the project Im working on is difficult to extrapolate the sample code to. I have the form creation down but cannot figure out adding items to a...
add objects
add objects and code programmatically
class add
class objects
command button
create code at runtime
create objects at runtime
dynamic userform
label
list view
tree view
webbrowsercontrol
Hi All
I was hoping for any assistance with VBA code which can return VAT registration details from HMRC's website.
If you click on the link https://api.service.hmrc.gov.uk/organisations/vat/check-vat-number/lookup/362012792 then you get a valid response as per the attached. By changing the...
Hello, remembers of the forum
I'm having troubles with webpage scrapping by using VBA
I know I can select element of page by using
- getElementByID
- getElementsByClassName
- getElementsByTagName
However, I have no idea how to get data by Attribute
For example...
The following code works well to click a search button, so long as the element has an assigned tag name. Unfortunately I am not able to locate a name element for the Search button on the Yahoo home page. Can someone PLEASE advise on how to successfully re-write the code shown below to click...
Hello,
I am currently running into a problem when trying inputting code into a web form. The code I have works fine for entering in the information but I am getting an error from the system stating that the entry is invalid even though its correct. If I copy and past into this field the...
I created a webpage that I need to render in a Web Browser hosted on a User Form in excel. When I launch the User Form the page loads great but the JavaScript doesn't seem to be working. I saved the contents to a text file and launched it in IE. I noticed that there was a warning at the bottom...
Hi,
I am trying to log into my auction.com profile to ultimately track commercial real estate cap rates that properties on auction.com are going for in different areas. I am having problems clicking the Log In button after my username and password (that are pulled from a cell reference) have...
HI all, I use the below code to load a gif on my userform using a web browser control. I have the control of the size 30x30. even if i choose a gif of size 25x25 it doesnot center on the control.
Seems like there is some extra padding or space added to the gif before loading.
Any idea how to...
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.