Visual Basic for Applications; a subset of Visual Basic used in all Microsoft Office applications. Consider using this tag together with the tag for the specific application in question.

learn more… | top users | synonyms

5
votes
2answers
268 views

How do I add VBA in MS Office?

I've seen posts showing answers which use VBA (Visual Basic for Applications) code/macros, however, I've also noted additional comments afterwards about how to use the VBA (how to implement it). I'm ...
4
votes
2answers
9k views

How do I use Excel 2010 Personal Macro Workbook?

I want all of the macros that I've written to always be available when I'm using Microsoft Excel 2010. How can I do this?
6
votes
4answers
50k views

How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: ...
8
votes
1answer
19k views

Recover sheet protection password in Excel

I have an Excel workbook. Two years before I set password protection option for one of the sheets. Now I have forgotten the password. Is there any way to recover the password of that Excel sheet?
4
votes
1answer
12k views

Find and replace multiple values within selected cells

I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original word; B with the translation. I already found the VBA code to get this ...
4
votes
3answers
29k views

Any Excel function that will reverse a string?

Are there any built-in Excel functions that will reverse a string?
2
votes
1answer
260 views

Excel VBA code Private Sub Worksheet Change Power function not working

I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is ...
1
vote
2answers
413 views

Outlook VBA macro to forward email attachment, but delete message body

I am trying to add a custom action to a rule in Outlook where a message is automatically forwarded and the attachment stays but the original body message is deleted. I need to write code for the ...
4
votes
1answer
4k views

How to replace text in the body of an incoming message with a hyperlink in Outlook 2010?

Does anyone know of a way or a program that will read a received email and recognize a static format of text (in my case it will be "#" followed by 6 integers), and make that a hyperlink to a webpage? ...
2
votes
2answers
3k views

How can I compare two columns in Excel to highlight words that don't match?

(I'm using Microsoft excel 2010) OK, lets say I have a list of phrases in both column A and column B (see screen shot below) What I would like to happen whether it be with a macro, VBA or formula ...
1
vote
1answer
247 views

When using multiple accounts, how to ensure emails are sent from the correct account

I use 2 email accounts with Outlook. One for work, one for personal. The problem I have is I am forever sending work emails from my personal account! How do I set up a list of "do not send email to ...
1
vote
1answer
2k views

Copying data from multiple word docs into one excel sheet

I have about 4000 doc and docx files which contain a table. I've managed to import these into one excel sheet using the following script: Sub Macro1() Dim xl As Object Set xl = ...
4
votes
1answer
29k views

Inserting a (jpg) picture into a cell in Microsoft Excel 2007

Is it possible to insert a jpg image inside a cell, or do Excel cells only display alphanumeric characters (or references)?
1
vote
5answers
23k views

Excel VBA “Unselect” wanted

I would like the final appearance after my VBA has finished running to be empty of selection -- to have no cell or range on any sheet colored (if it was range selected) or in a bold line box (anything ...
4
votes
3answers
1k views

Calculating the average of variably sized blocks of numbers within a column?

In column A I have a set of numbers (over 1,000), and I want to get an average of a block of them at a time, (e.g., 10, so A1:A10 then A11:A20 and so on) and write these averages into column B, such ...
3
votes
1answer
4k views

Show Excel column filter information in cells

We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual ...
2
votes
2answers
2k views

VBA Excel 2007 help to speed up code to hide rows [closed]

I am trying to write a VBA code that automatically hides rows if a value in the row is equal to "". My range of values is A37:A400. Because my range is so big my previous VbA is to slow and looks one ...
2
votes
3answers
14k views

Excel ran out of resources while attempting to calculate one or more formulas

I received the error message "Excel ran out of resources while attempting to calculate one or more formulas" on ONE of my computers (Out of 2). My worksheet contains: (Inside a single worksheet, not ...
2
votes
4answers
10k views

Filling cells with sequential numbers in an Excel (2003) macro

I need to fill an excel column with a sequential series, in this case from -500 to 1000. I've got a macro to do it, but it takes a lot of lines for something that seems like it should be a single ...
1
vote
1answer
69 views

How to create multiple rows combining data sets

I have three tables and i need an out put which has data from two tables, i would like to create the same using macro. Table A A B C D Table B Apple Orange Pears Table C Americas Asia Europe ...
1
vote
1answer
870 views

How to check data exists or not in array and add items to array using VBA

I always write data 【AAA, BBB, CCC】into CSV file. I would like to also write other data (eg:DDD) if there is in text file. An array: arr = Array("AAA", "BBB", "CCC") Text File(Read): AAA BBB ...
1
vote
1answer
123 views

Sorting cells in a column is easy. But how to sort cells in a row?

Assume school language learning exercise, based on making right order of words in a scrambled sentence. Then put numbers into the next row, specifying the order the words should be in. Now select ...
0
votes
2answers
1k views

How to add custom styles to navigation pane or change them with VBA

I have a Word2010 document that was created by a tool from Axure. Each heading is formated with a custom style ("AxureHeading1", "AxureHeading2", "AxureHeading3"). I was able to create a table of ...
0
votes
1answer
80 views

Clever way to connect multiple images to on-click macro - VAB Excel

I have asked this question before, but admittedly in a terrible way, so I am asking this again. So here I am once more. I am making a program in VBA Excel - or better, combining a certain worksheet ...
0
votes
1answer
747 views

How to combine values from multiple rows into a single row using module?

I'm looking to combine multiple rows into a single row based on a value in the code column.. I've noticed other questions on here similiar to my question but I cannot seem to extend the range.. Code ...
18
votes
5answers
7k views

How can I use custom colours in the Microsoft VBA editor?

I'm working on a few projects for work using Excel and VBA, so I have no choice but to use the Microsoft Visual Basic editor. I normally wouldn't mind, but I can't figure out how to set a custom ...
4
votes
10answers
45k 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 ...
1
vote
1answer
9k views

Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive. I have an Excel workbook which contains around 50 columns I have a criteria column for splitting this workbook into mulitple workbooks The approach is as ...
2
votes
1answer
516 views

Macro to merge cells in a column if the same rows are merged in a different column

I need help finding a macro that can merge cells across rows in a column if those same rows are already merged in another column. Below is a screenshot of what I have now that shows the cells that ...
2
votes
2answers
5k views

Excel - Create text file named after a cell containing other cell data

I'm looking to create a .txt file for each value in column A containing the corresponding values in columns B and C
1
vote
1answer
6k views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
1
vote
4answers
4k views

How to input only unique values in a column in Excel 2007

I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...
0
votes
2answers
13k views

Excel 2010 VBA - Trigger macro with ONE click on specific cell

Would you mind pointing a way to start a macro in Excel 2010 by clicking only once on a specified cell? I had seen a solution somewhere, but now I can't trace it back.
15
votes
1answer
54k views

In Excel 2013, where are Visual Basic, VBA, Macros, AddIn Tools?

In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
2
votes
1answer
42 views

Can I run a VBA function whenever excel calculates, even when I don't click F9?

This is a followup question to this one: Can I make Excel beep when a calculation is finished? The answer relies on me pressing F9. However, even with calculations on manual, sometimes calculations ...
2
votes
1answer
191 views

Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here: Excel function that evaluates a string as if it were a formula? Problem is this does not seem to work with a function in there. This ...
2
votes
2answers
2k 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 ...
2
votes
2answers
2k views

How to replace cell formula with its own value via UDF?

Problem Description I have a custom formula that I wrote, but it takes a while to calculate the answer, and since Excel updates function values (When you activate the workbook, or re-open the ...
2
votes
1answer
1k views

In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?

In Excel, I pasted in a bunch of URL's into a column. However, they aren't live links after pasting. How do I bulk convert them all to live links swiftly?
2
votes
1answer
3k views

Automatically move deleted Outlook items to archive folder after two weeks

Is there way to set up a rule in Outlook to automatically move my deleted items and sent items after a certain amount of time, say two weeks, to an archive folder? If it can't be done with a rule ...
1
vote
2answers
70 views

Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...
1
vote
2answers
95 views

Hiding all but the selected rows of data

I am unable to send any pictures, The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...
1
vote
1answer
78 views

Excel automatically adding an extra row with formulas for the inputed number of years

I am looking to build a model. I would like to have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
1
vote
1answer
1k views

Find and replace multiple words in a column in Excel 2007

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
1
vote
1answer
2k views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
1
vote
3answers
216 views

Assign triggered code to multiple images - Excel VBA [duplicate]

I wanted to assign some specific actions when clicking on one of the images I have inserted in my Excel sheet. The problem is, I got 52 images (Poker cards for those wondering). So, my question is, is ...
1
vote
1answer
389 views

Convert Plain Text to Hyperlink in Outlook

I am putting together a POC for my company regarding some monitoring tools that we use. As part of my project I need to convert portions of a plaintext email sent to me into a hyperlink (I am not ...
1
vote
1answer
3k views

How to avoid references in VBA (Early Binding vs. Late Binding)

I found a VBA macro that prints Outlook attachments automatically. A rule triggers the macro. But the macro needs a reference to Microsoft Scripting Runtime to work. I saved the code in ...
1
vote
2answers
2k views

How to combine values from multiple rows into a single row

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined, but only if the cell above is empty. I ...
1
vote
1answer
4k views

Prevent Excel 2010 user from pasting formatting into cell

Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...