button

@Jaafar Tribak - I have seen that you have extensive experience in this topic so I am hoping that you can help me please. I have an external application that I can launch and control from Excel, but only up to a point. As soon as I click on the SEND TO button and the menu pops up I can't go...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

HI, I am wanting a Macro button setup so that when a value is entered into cell E1 and then the button is clicked, a pdf opens up from a folder on X drive. Refer below snip. (Ignore the Display and Reset buttons, I am just after the Layout button) Can anyone help me with this please ...

I have a macro to copy and paste a table from one sheet to another. I used macro recording to get this VBA: Sub CopyPasteNew() ' ' CopyPasteNew Macro ' Copy table from "New Term Deal" to Active/open sheet ' ' Sheets("NEW Term Deal").Select Rows("3:27").Select Selection.Copy...

Hi, I have made a table which is for writing hours at work. I recorded a macro where i copied the C6:C17 range and pasted it one to the rigth (D6:D17). I then assigned the macro to the button so when i press it, it adds another column to the table. The problem is that this only works the first...

Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...

Hi, I would kindly ask for help to accomplish this instructions using VBA: I already looked everywhere and no luck, any help will be really grateful.

Hello, I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either. I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel...

One of my sheets contains a dummy randomization schedule for patient entering a study. In the second sheet I would only like the current randomization to show, so one randomization at a time. And then when you click on the button the sheet updates to the next randomization. Any leads on how...

I'm a contractor and i use an excel workbook with different sheets (please see attached). i've been making more and more changes to it. i want to be a to click the PO button and have it create a new sheet from my "PO template" sheet in the workbook. i also want it to pull the contractor name...

hello all :) i'm putting a NEXT and PREVIOUS button on my userform to see other data (from other rows) ... strangely they work only once, and i think why: the activecell.row is stored in a variable, but in the datalist the active cell remains on the same row. how can i change my code to make...

Hello, I wanted to see if it is possible to create either a button or a drop down that can take me to a section on an excel sheet. I have 10 sections that are the same but can take different values in the section The title "Section 1" is on C12 then the next section is c78 and so on meaning...

I have a document that I’ve made with two tabs “shift report” and “machine data” which both pull various formulas and data from each other Is there a way I can create a button / macro that would copy both tabs but the formulas for the new ones would correspond with each other Eventually you’d...

Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...

Hello Everyone! Happy New Year! I am making a model and would like to create a landing page where I would type numbers and click on a button. When I click on this button it creates a copy of another sheet and makes the adjustment stated on the landing page. Is this possible, if so how can I...

hello everyone, Does anyone knows how to have a button with macro function that when i press it, it copies D4 value and paste it in toppest coloumn available of Table 1 (From A7 to E22) and colourize it green

Hello, I'm trying to set up a file that makes it possible to search through a pricelist and quickly adds the data from the item you picked to another table (where you do all the calculation ndr). I solved the search part through a simple Conditional Formatting Formula, but I've no idea how to...

Hi all, I am trying to make a randomizer in Excel to randomize my workouts. I currently have 4 workout lists in Excel: Abs, Arms, Chest, and Legs. The lists are made of strings with no numbers. What I want to do, is to have 3 different buttons, each for a different day (Arm, Chest, and Leg)...

Hi all! I want to create a macro that will find a certain column, based on the value of a cell in that column, and copy/paste values the data from that column to another sheet. The reason why i need it to find based on a value of a cell is because i have "customizable"/"moving" columns and...

Hi! I have the following code on a sheet, this is a heavy workbook and I'm worried if its continuously running with every click it will slow down the user. How can I modify this to run only on the first click on the ActiveWorksheet, or so i can assign it to a button to be only run when clicked...