A macro in computer science is a rule or pattern that specifies how a certain input sequence should be mapped to a certain output sequence according to defined rules and procedures. **Consider using [tag:vba] tag instead of this one if the question concerns a Microsoft Office product. This helps ...

learn more… | top users | synonyms (1)

0
votes
0answers
10 views

Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled

I'm trying to adopt the solution from this post & I've modified the macro slightly (I only need to add on button click) so that it's now Sub AdjustValue() Dim btnName As String Dim ...
0
votes
0answers
12 views

Formatting paragraphs in Word based on leading characters

I'm trying to prepare some VBA code to be easily readable, so I'd like to highlight all the comments in the code by applying a more visible Style. However, there's quite a lot of them, so I'm looking ...
-1
votes
1answer
446 views

How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...
0
votes
1answer
23 views

How to display unique numerical values from different columns into a single cell (separated by commas)

I have a unique problem I have been trying to tackle with no avail. I have scoured through the internet but only found partial solutions and not a complete solution. I am looking for a function (or ...
0
votes
0answers
5 views

Pasting entire macros in a remote console shell

I am configuring a server using its remote console (which is not SSH, as I haven't installed the OS yet). Unfortunately after a long series of driver failures I end up repeating typing the following ...
0
votes
0answers
22 views

Creating a dropdown submenu in PowerPoint

I would like to know if it's possible to create a dropdown submenu in PowerPoint like the one for inserting a WordArt: If it's possible can you share with me some documentation about this?
0
votes
0answers
14 views

EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro ...
2
votes
2answers
4k views

How to add a custom command macro in Windows 8 speech recognition

I have tried a few options but its not working for me. I am using Windows 8 Pro. Can anyone show me how I can write my own custom command macros for speech recognition in Windows 8? I have tried ...
0
votes
1answer
541 views

Combine duplicates in Excel based on values from 2 columns, produce the sum and and % from others, remove dups

I have been struggling with my Excel report trying to roll up duplicate rows based on 2 column values. Also need to calculate the sum of the 3rd and 4th column and calculate the percentage. Here is ...
-1
votes
2answers
28 views

how can i make my macro toggle a sheets visibility/hide?

i have the following code that i want to toggle a sheet being visible or being hidden: Sub toggle() If Sheets("Navigation (2)").Visible = True Then ActiveWindow.SelectedSheets.Visible = False ...
0
votes
1answer
16 views

Excel Macro to draw xyscatter plot out VBA

I am trying to create a xy plot where the x values is the time axis (column A) and the y values are in the other columns. (in the example only C and D) When I try my code from below, I get a graph ...
0
votes
2answers
22 views

how can I see what TYPE of data is in my macro?

I have the following code that doesn't work inside a macro: count = Application.Sheets.count ans = type(count) msgbox("count is " & ans) but this doesn't work cause I think type is looking for ...
0
votes
1answer
27 views

VBA warning when cells selected are not equal to 5 and contiguous

My Vb macro does the following: I select 5 contiguous cells, run my macro and I get 5 static random numbers between 1 and 50; It works perfectly; I need a warning when the selected cells are not ...
0
votes
1answer
3k views

Excel 2010 Legend key color based on text

Background I've an excel template. This template I populate with data by running a program I've written. The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
1
vote
0answers
18 views

run time error 1004 method open of object workbooks failed

I have this issue on one single PC only, and the error relates to opening an Excel workbook based on a macro-enabled template (xltm). Xltx files work fine. (Macros are enabled on this troublesome ...
3
votes
0answers
15 views

Terminate the Access macro after a specific time

I am running several MS Access macros from a batch file. The macro runs several queries in AccessDB. Things are working fine. But, I want to add a check. If a macro runs longer than a specific time, ...
3
votes
2answers
21 views

How to apply a macro/vba formula to more than just one cell

I have entered the follows: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$V$2" Then Range("U2") = Range("V2") * Range("O2") End If If Target.Address = "$U$2" Then ...
2
votes
2answers
3k views

VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses. I need a Macro/VBA that moves any word in red from column A into column C as a list. However if the same word is ...
3
votes
0answers
20 views

Run a program and return value libreoffice calc [migrated]

I wrote an algorithm in c that takes input of double precision numbers and returns a double. I would like to use this in libreoffice calc. I tried making a macro function using shell but it only gives ...
0
votes
2answers
48 views

Adding or Replacing text within hyperlinks

I am very confused after trying to explore how this can be done. Its very simple but yet cant find a solution. What I wish to know is the following. I have three separate documents, all of which are ...
-1
votes
1answer
1k views

How can a macro be created to insert a text box pre-populated with text in Word 2010?

I am attempting to create a Macro to insert a textbox populated with predetermined text when a shortcut key is selected. I am able to record a Macro to generate the text but I am unable to get it to ...
0
votes
1answer
29 views

How to default Macros to run from This Workbook, NOT All Open Workbooks?

We have a macro enabled workbook (ver. 2010) that many people use. A few of these people have macros in their Personal.xlsb workbook. We have a situation where the macro in the shared workbook is ...
0
votes
1answer
35 views

Using libreOffice Calc function in macro

I am trying to create a basic macro function in calc to perform a hexadecimal to binary conversion with more then 10 bits. But I've got a lot of troubles. First, where can I find actual ...
2
votes
5answers
5k views

Word 2010 How to Create a Macro to auto-insert Author Name in the Footer?

In a template document I want to create a macro that when the template is opened and a new document is pulled up, the "author" name will automatically insert into the footer. Is this possible? I don't ...
1
vote
1answer
26 views

MS word macro: how to change highlights form a specific color to another — inside the selected text?

I want to change the yellow highlights in the selected text (not in the whole document) to red highlights. This VBA does change the highlighted colors but it does not stop at the selected text (it ...
1
vote
2answers
3k views

Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...
3
votes
1answer
6k views

Can i stop a blackwidow macro while its being executed?

I'm trying to make a macro for my blackwidow keyboard, which has to be executed until i press a different button. Can anyone tell me how to do this, or how tp stop a macro from being executed halfway? ...
1
vote
1answer
35 views

Macro does not run when opening a File/Workbook from within Excel

I'm new to Macros and VBA in general but my goal is pretty simple I believe. My macro should search an opened Excel document (automatically) and create a MessageBox with a warning if the WEEKNUM() ...
0
votes
1answer
7k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
2
votes
1answer
23 views

How can I use conditional formatting or a macro to italicize duplicates (but not the original) cells?

I have a spreadsheet in which there are many duplicates (intentionally), and I would like to highlight the duplicates but not the first instance of a cell. Below is an example row: A A A A A B B B C ...
1
vote
0answers
16 views

How can I set Microsoft Word up to change any text encapsulated in `backticks` to monospace?

I wish to be able to type `simple code` in between backticks as shown, and have Word automatically change the font to some monospace variant. I am aware of alternatives such as LaTeX, but would like ...
0
votes
0answers
21 views

why does this select statement fail? it works as a macro but not as a button

i recorded a macro that selects a sheet and then a range. it works as a macro but it fails as a button, just want to know why? Private Sub CommandButton3_Click() manfix = InputBox("Enter in fixture ...
0
votes
1answer
33 views

Excel 2010 VBA click cell trigger macro to show list of values

When clicking on cell say d2 I want to show the values from j2:j6 in e2:e6. When clicking on cell d3 I want to show the values from k2:k6 in e2:e6, etc. Can someone help me? thanks
0
votes
1answer
56 views

How to view and change the assignment of keyboard shortcuts to existing macros?

In Microsoft Excel 2010, I have a macro assigned to a keyboard shortcut. Strangely, it's not working properly. I want to double-check the keyboard binding. How can I view and/or change the ...
0
votes
1answer
60 views

Multiply the Sum of one Cell if another cell shows value

I've added a hidden cell (T259) which calculates 10% of Cell U78 if "Mortar Joint" is selected in the Sales Agreement sheet. I want to add a function in cell U78 to add the value of T259. I am getting ...
12
votes
14answers
77k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
0
votes
0answers
222 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
0
votes
1answer
49 views

Macro for Reapply Filter on Excel 2016

I have a Mac and am running Excel 2016. I have an Excel sheet which is auto-filtered by date. Until recently, I had a macro saved which allowed me to press Command+Option+n and it would reapply the ...
3
votes
1answer
517 views

Macro Find: Is there a macro to Format a Word Document as if it were being created in VBA?

I have a lots of code (for Excel) in VBA and would like to transfer a copy of it into a Word document. Does anyone know of a macro that will format the Word document to treat the code as if it were ...
0
votes
0answers
16 views

How to display URL's as Thumbnails into Excel [duplicate]

I am quite new with Macro's in Excel so hope you can support me. I do have many URL's shown in Horizontal lines (B2-E2 and B5-E5) in Excel 2013. What I would like to do is to show the image ...
1
vote
1answer
4k views

EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts. The first worksheet contains the master part numbers for the assemblies Each Worksheet represents the ...
-1
votes
4answers
5k views

How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel? For E.g Consider the below image : After conversion it ...
0
votes
1answer
48 views

How to populate information from one sheet to another in Excel Workbook?

My current task is to create a formula where my information from one sheet will auto populate in another sheet when the product description is copied. To be specific, we need to have the items ...
0
votes
1answer
51 views

Create function by check box object name (“Dynamically”)

I have multiple check boxes in a sheet, and in another sheet I have a form. When a check box is selected, then the appropriate content will be added as a column in the form sheet. I have over 500 ...
1
vote
1answer
18 views

Fix irregular shape of merged tables in MS Word 2007

I have been looking for the answer to this for quite some time, but to no avail, so I hope someone here will be able to help me. I have recently exported a document from FineReader 12 to word. The ...
0
votes
0answers
8 views

Excel, Ascending Workbook Default Filenames

Disclaimer: I'm very new to using VBA, so please bear with me! I'm currently using the following macro to quickly export 4 specific pages from a larger workbook to a new workbook that gets emailed ...
1
vote
2answers
674 views

Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function: Function GetDate(strInput As String) As Date ...
0
votes
1answer
37 views

Macro exports date column to csv as numeric value rather than dd/mm/yyyy

The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy. How to I amend the code to force B2 to export as ...
1
vote
1answer
23 views

Macro to transpose based on nearby column number [closed]

This screenshot has details on what is needed. (Click image to enlarge) I need a macro that can perform the following in Excel: Use column F numbers (Line Count), to place in the values from ...