I have a workbook that has 2 similar worksheets. One called "Wood Shafts" and the other called "Iron Shafts" I have the macros worked out for the sheet called "Wood Shafts" and I just realised I need to apply similar Macros to the sheet called "Iron Shafts" (same functions but different values from different columns). Some how I need the code to be able to tell the difference between the two sheets. I am at a loss.
After all the awesome macros I've obtained with the help of all of you, I now have over 30 macros, each in its own module. I have tried without success to re-name the modules with no luck. How is everyone organizing these?
I have a workbook that when I open it opens a toolbar that was designed for it. I have been asked to make changes to this toolbar. One of the changes is to allow shortcut keys to run these modules. I have tried recording a macro and viewing the code, I tried applying this code there but it does not using the shortcut key. note that this toolbar is only available to this workbook, so these macros are not available to the personal workbook.
when we record a macro it gives us a option to assign a shortcut key to that macro how ever that is only in combination of "Ctrl" my question is that is there a way by which we can use any other combination like "Ctrl"+"Shift"+ <key>
I have a macro where I am assigning a variable and the value of the variable is a path where the data is stored. i am trying to assign a shortcut key for macro, i tried to run the macro by going to the vba mode and then click on the F5 function key and the macro run absolutely fine. but when i use the shortcut key the file just opens and just exits the macro.
Code: Option ExplicitDim a, b, c As Long Dim myFolder As String Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sql As Variant Sub Macro1() Application.DisplayAlerts = False
i wrote the program and created a button on the toolbar. what i did not know was other people outside of my location will be using this program. so when they get the file, they will have to reassign the macro to the button since the file location will be different. i have already written instructions with screen shots in case the boss wants to go that way. i would like to do this with code. they would run another program which would get the path and name of the file and assign it to the macr.
I have written the code below. And I found two problems:
1.The code stopped to work when I change from Paste to PasteSpecial.
Sub Copyfriction() Dim DestWB As Workbook: Set DestWB = ActiveWorkbook Dim DestWS As Worksheet: Set DestWS = ActiveSheet Dim DestCLL As Range: Set DestCLL = ActiveCell Dim UserChoice UserChoice = Application.GetOpenFilename(FileFilter:="Text Files (*.xls),*.xls")
2.As you see the right cell on the the destination sheet need to be selected. So Im planing to run the macro when double clicking the cell in question. I have tried the next
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address = "$A$6" Then
Is there any way to define a shortcut for an exisiting macro. The reason for this request is that after a lot of struggle I got a VBA code to work (as a macro)... initially I had created an icon and had linked the same to this macro.... However I feel that defining a short-key would be much more productive.
I have a rather large workbook with around 10 sheets. i want to setup a 'export' button on this workbook that will allow a user to save raw data from this workbook into another excel workbook and an ' import' button that will allow user to import raw data and use the existing formulas/links from this large workbook.
As in sample file, i want to be able to export/import all the cells that are orange in colour (in my actual file, all raw data cells are not actually orange, thought colour coding it would make my problem easier to understand)
I was thinking around these options:
1) Copy and then PasteValues from the large worksheet into another workbook for exporting and same idea for importing
2) For all raw data, copy out all the values and put their corresponding addresses in another excel sheet. e.g. column1: Sheet1!$A$1, column2: value and import it in by reading the address n value.
I found a macro on this forum that I think will work for the first part of such a module (If I modified it correctly). It should give me the ten second timer part of my problem. What I need is the second part of this module to add one to the value of A1. I'm sure it's something simple, but I don't know where to start.
I'm working on MS Excel 2010 and trying to have a macro duplicating a sheet(and it's associated macro "Update") in another workbook.
I manage to do almost everything except to import the required module "Update" from a precise and static folder ("Ressource" located in the same folder as all the workbooks) into my active workbook, which is surely possible.
Moreover if you know a way to check if a module already exists and in that case overwrite it, I'd be even more grateful. Presently I just skip the error if it exists.
Here is my actual code:
Code: On Error GoTo ErrImport ErrImport: If Err.Number = 1004 Then MsgBox ("Already there")
I have some excel sheets that are formatted like the following:
COMPANY | TOTAL | R | G | B company1 | 10 | 255 | 000 | 000 company2 | 20 | 000 | 255 | 000 company3 | 30 | 000 | 000 | 255 ... and so on...
My question is that I would like to have a macro that runs on this basic file and creates a bar graph with the data. Then it utilizes the RGB values in the columns to change the specific bar for that row. So setting the r, g, b as variables corresponding to the columns in the sheet. Also there isn't a preset number of rows in the files.