button code

I am trying to find a way to create a button that will upload data from a pdf file. I am familiar with the "Data>Get Data>From file>From pdf" way of importing the data and am simply trying to create a button that allows the user to open the display that allows them to select a pdf file to...

Hi, I want to add a button either side of a cell to decrease/increase the value of the middle cell by 1. I know how to do this the long winded way by adding an individual button and targeting the specific cell, but going into the macro code to edit the target cell for will take ages, especially...

Hi Everyone, my probleme is that when when i shift cell up using a VBA button all the formula using that cell as to do calculation become #ref! because the ref have shifted up by one cell. The formula i use to delete and shift cell up: Range("B6").Delete (xlUp) Example : i want to delete the...

Hi All I am scraping a website, using XMLHTTP, that holds information about football matches into an Excel sheet. Most of the data scrapes easily but I cannot access data held within a button. The the page I'm scraping is Latest Football Fixtures & Betting Odds | Soccer Base Here's my VBA to...

HI There, Need Urgent Help to Build a Code for one Work project workbook I need once cell value Matched wi Once the value match from Sheet 1 Cell5 to Sheet 2 range (A4:A7) then copy from Sheet 1 Cell ("C9", "E9","G9") a specific cell & paste to a specific cell Like Below Example Sheet 1 Cell...

Hello guys, first time posting here (an first time posting in a forum ever). I'm desperate. I am programming an Excel File to act as a game interface (a very simple one, for a gamification project in my company). The thing is that I want to create an ActiveX button (why an ActiveX and not a...

Hi, on an internal web which only runs in IE or GC there is a button with id="ext-eng-123" where 123 is a set of 3 numbers that change everytime the page is clicked. It appears it is a set of up to maybe 20 different combination, so not many. The whole line reads: <td align="left"...

Good afternoon, I created the following macro to move a few numbers and then clear data from cells. The macro works perfect. I was hoping to add a clear button for some to just push when they needed to clear the spreadsheet. When assigning the macro to the button (on sheet "Blotter") it tries...

Hi all, I am attempting to build my first dynamic userform. One problem I am having is probably pretty simple, I just don't know the answer. The second & third questions I will post separately as they are not a priority at this time. Background: I am designing a dynamic form so that the end...