click a button

Hello! I have a query for you all. I have a spreadsheet that lists an attachment number amongst other things. I also have a directory that has all of the attachment files and those file names match the attachment number from the spreadsheet. I want to be able to click on a link or button and...

I need 2 macros, one for a button when clicked to insert the text "NO", a second macro for a button when clicked to insert the text "YES". Both in range "B7:B200". Meaning if I click the button "NO", it will insert the text "NO" in first cell from range "B7:B200", meaning B7. After that if I...

Hi there, Old thread I know, I'm having a little bit of trouble getting something to work. I'm also a bit of a novice, I'll admit. I'm trying to Populate a table, this I've succeeded in. Now however I need the information in a specific cell to be read and held against a portion of my table to...

I have a code that logs in to a website as it should but when it goes to click into a drop down menu it errors "Method 'Document' of object 'IWebBrowser 2' failed" and errors on this line IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click Here is the full code: Sub test()...

Hi. I am trying to use my VBA code to click a button on an IE Web page. I have tried various lines of code but keep getting the Object Error 424. Below is the web page code detailing the button.... <td id="cellInvestment </br>Choice" align="left" name="cellInvestment </br>Choice"...

Hi there guys, hope that you're all well. I'm writing to you to ask you for help to create \ develop some macro base on combo box and click button that allows me to create a PDF based on some selection (criteria) that should be defined by me, previously (prompt, combo box, other suggestion)...

Hi, So i have been searching hundreds of forum threads for an answer to this, but its been convoluted due to the website layout that i am working with. I have code that goes to a website and needs to click on a button, but the button doesnt seem to have the same labels that i normally see in...

Hi all, I have the following code that allows me to access the website and select 100 entries per page, although I cannot figure out how to click on the button "Next 100" to access the next page. I tired just navigating to the on click event in the html but that had an error of something like...

Hi guys, I have made a program that will put addresses into the website Distance between two addresses, cities or zipcodes But I don't know how to get excel to Click on the "calculate distance" button. I've looked on a bunch of youtube videos (which is why I'm able to put values into the...

I have a sheet1 and sheet2 If I click on cell a1 in sheet1 then data should be copied to sheet2 a1(not formula) then I click on cell a3 in sheet1 then data in a3 should copied to next blank cell in column a of sheet2 that is sheet2!a2 not sheet2!a3

I have a vba macro with the following structure: - Open a Form A (vbModeless) - In form, I have tons of controls. Two of them are command buttons. - When I click on button 1 - another form (B) is displayed. This one is Modal. - When I click on button 2 - another form (C) is displayed...

I have an Excel file I am using as a grading rubric. I have 5 different cells with text only in them. I need to be able to click on the cell and generate a score on the sixth cell, which is empty. For example, if I click on the first cell with text, the score is 1 and that 1 needs to appear...