command

Hi all, Just starting out with Macro and recording (not yet moved on to VAB and coding) and have got stuck / cant locate any advise on the following. I have created a 'Quotation' template with Macro command buttons to generate formatted pivot table and open a Word document for emailing. These...

I have a spreadsheet that takes a list of file names, modifies new file names, and creates the "ren" command to execute using command prompt. So I may have 50 rows from F2:F51 that look like this: I want to create a macro that pastes this into CMD to run. Normally, you can open CMD and just...

Hello, I have a user form with 3 text boxes and 2 command buttons. My problem is getting text box 3 to perform a calculation based on cost price in text box 1 and the percentage I need to reduce it by to show the discounted buying price. So for example, if a product costs £100, take 20% off...

Hi All, Is it possible to have a command button on a sheet which when pressed creates a copy of the sheet and puts it at the end off all the existing sheets but also has the command button on it, so when I've finished filling in the new sheet I can keep creating new sheets? Thanks

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...

Hi everyone. I have this command "Application.OnTime TimeValue" on my workbook while it is open. I just like to know if that command will continue it's assigned task based on the time given on everyday basis or just the day that the workbook is open? Thanks Application.OnTime...

Hello I am looking for a code that when the command button is clicked it will change "B1" Private Sub CommandButton2_Click() If "B1" = 1 then "B1" = 2 else If "B1" = 2 then "B1" = 1 I realize this is not a code it's just and example of what I'm looking for. Thank you

Hi all, I have been searching for a good day (if not more) on this so, I apologise if it has been answered before. I have a spreadsheet with a command button basically when I click the button what I want to happen is:- Excel looks at value of a specific cell (B2) Based on the value in that...

Is it possible to apply a fade from one colour to another on an active x command button?

Age is a terrible thing!! Can't remember the command for = ("abc",1,"def",2,"ghi", 3) the number returns the corresponding string (or maybe vice versa). Can anyone help? Thanks.

Hello Will this command delete empty cells in that range? Range("A1:A10").SpecialCells(xlCellTypeBlanks).Rows.Delete Shift:=xlShiftUp

if I have some photos stored with command button page Is there any way that I can delete the photos only but not command button together by F5/goto/object if no, any macro that can do it? I had around 200photos in column F thanks for the help

Just wondering how others may get around this. My form processes a pile of data, comparing various values. If it finds a difference then display it and wait for the user to click a "Continue" button. But I don't want a msgbox. What else does the same job? Ideally just a button that waits to be...

The command dir /S /B /A:-S > FileList.xls lists every folder, subfolder and file except for system files on a worksheet. I want the user to be able to select a folder, and obtain this result without having to run a command prompt. Is there a way to run this command from VBA? Thanks.

Is there a toolbar ribbon method to put a linefeed within a cell? I have a user who wants multiple lines within the same cell. Unfortunately our users access Excel through Citrix, so the standard ALT-ENTER command is unavailable. ... it actually logs them out. Using Wrap text won't work...

Hi I've a Macro called Sheet3. Find_First2 I've set up a user form and in it there's a command button that I need to run the above macro. I'm using the below code but won't work for me, just highlights in yellow. Private Sub CommandButton1_Click() Sheet3.First2 Unload Me End Sub Any advice...

Hello I would like the font on a command button to adapt to the amount of text. If the amount of text from Range("SeqName") is too much and the button is allowed to autosize, the button fills the entire width of the userform. I looked for a shrink to fit option, but no luck. Is there an option...

What is the code I would use in a command button to copy the excel page, so it can be posted to a Word Document and others?

https://drive.google.com/open?id=1TfqRi0g6FwDCY0iNOfVWOyLhAXgBPygR I'm trying to write a VBA sub to look up the value of two references on different sheets. The problem I've got is the value being looked up has entries in more than one row which I believe is difficult for this command. I was...

Excel 2007 Create a command button to copy data in a range then find the last row in another sheet and paste. Sheet “PROJECT TRACKING” I placed a command button within “L6”cell. Each time the button is clicked, I would like the data copied from column “C” through Column “K” in row 6 and paste...