command button

Hi, I'm wondering if there's an easier way to do this, which is user friendly and can cope with new accounts being added. Currently I have the below code, which works great. However, I have 100 accounts and the below code is for just 3 accounts. It is going to be very time consuming writing all...

I have a code for a button that creates a new column at theend of a table. After the new column is added, I would like to have theformulas from the previous table column to fill into the new column. The datain the table should be the only formulas filling to the right (table headersshould not...

I have a named range on sheet Competitor Comparison Data called “CCData”. I would like to add a new column to the end of the table every time I press a button. With each button press, a new column is added to the end of the range and is then included in the named range. The new column should...

I have a dynamic range that expands when I add new data(naturally). I would like to add code to a button that I have that will adddata to the range when the button is pressed. This is the line of code I amworking with: Sheets("Competitor OverviewData").Range("CompetitorsLOV").Offset(1, 0).Value...

Hi, I am trying to design code to create a defined name for a cell based off the value of another cell. The cell that contains the name that I would like to be the defined name is in cell (“C2”). The cell that I would like to obtain the defined name is the cell above the new column create from...

Hi, I would like to be able to assign a command button to add anew column to the end of my table. Each new column added should appear to theright of the last new column added. The command button will be on theactivesheet but the table in which I am trying to add columns to will be onsheet...

Hi, I would like to be able to assign a command button to add a new column to the end of my table. Each new column added should appear to the right of the last new column add. The command button will be on the activesheet but the table in which I am trying to add columns to will be on sheet...

Can i have a command button on my dynamic worksheets to perform the below function (I have created a button to copy the work sheet, so the new buttons would be copied too ). 1. View button - to highlight or show a range of cells / table in the worksheet 2. Color button- selected cell would be...

Hi All I currently have a worksheet with two command buttons by pressing one it hides all columns in a range that are blank, the other unhides all columns in that range. Is there a way to combine the two so i can use just one button "Hide/Unhide"? This is the code i have to hide columns: Dim...

I have a macro that calls a user form. When the user clicks the "ok" button on the user form, a command-button-click macro runs, which sets a global variable ("formVal" to the value of one of the form fields. All that works well. My issue is when I then run a macro in a different module (but...

Hi, Is it possible to run more than one macro on a Command Button and if so, how do I go about doing it? My Code below works for one macro (PDFRentalStmtNo1) but returns an error once I add the other two (Asset_Hide_Pro_1 and Asset_Hide_Chat_1). Thank you! Private Sub CommandButton1_Click()...

Hi, I'm trying to hide a command button if cell D8 does not equal 1, 2, 3 or 4. D8 is a dropdown, so changes manually. I have the following code below (which may or may not work) but I'm having difficulty including it with my other code (also below) as I keep getting errors. Can someone help me...

I've been making up a workbook for material summaries at work, and I'm finding a problem on 2 of 4 computers running it so far. Here's what happens: There's some command buttons shown in the picture. the mouse is hovered over the 'refresh summary' button (circled in black). (the cursor isn't...

Hello, Need help in the below code. I am calling a command button sub procedure using the loop. When I did it without loop I used Sheet3.CommandButton3_Click and it worked fine. But, then I am doing it using loop then I change it to ActiveSheet.CommandButton3_Click which is throwing error...

Hello, Let me start by saying that I am very new to VBA coding, so I'm sure I am making a simple mistake. I found similar questions to this on the forum, but none had exactly what I'm looking for. I have a document that is updated daily to track certain progress in my work team. I have...

I create a button in sheet1 and this is works only in this sheet not in sheet46. The problem is I need this button in another page(sheet46) I mean call this action from another sheet46 with the same reference (check sheet 1 and sheet2) Why don’t works? Code: Private Sub...

I am creating a blank worksheet with various procedures that automates another application (AccuTerm Terminal). My issue is that I am wanting to add a line to each ActiveX Command Button that will resize the button to a range. For example, let's say I have this command button: Private Sub...

I'm sure this is an age old problem. The difference in Command Buttons and Shapes. And while you can run Macros by clicking a Shape, you can't run VBA Code by clicking on a Shape. Am I right? I've written workable VBA code for Command Buttons. They work fine. But, the look and shape of some of...

I am trying to write some VBA so create a save as button that saves the document into the correct location and creates the correct file name... I am a bit of a VBA noob, I can do basics but this has me stumped!:confused::confused: Please see the code below that I have tried to butcher from...

Hi All, I have created a report template that is populated when people enter data using a userform. It is working as i would like andwhen data is submitted the report template is populated correctly. Now i would like to add a command button to this report template so people can save each...