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

0
votes
1answer
20 views

Excel 2013 global automatic macros

I am trying to log the opening and closing of excel workbooks to replace the Journaling capability in office. I have created and tested VBA auto_open and auto_close macros in excel, which log these ...
0
votes
1answer
20 views

Inserting 'n' blank rows using a macro

I am currently trying to develop an excel spread sheet to make it easier to format. What I would like to do is create a macro to insert blank rows in multiple places without affecting subsequent rows. ...
0
votes
2answers
44 views

How do I copy value in different column from previous row if the cell is not empty?

I have the following situation: A B 19260218 234 77 ok 3 ok 19310328 174 46 2 When the value in column B is numerical, I have a ...
3
votes
1answer
31 views

Why can't I use a number wildcard to in Cells.Find in VBA?

I'm trying to search my Excel worksheet for any cell that has a value that begins with a number followed by a period, but this isn't working. Does anyone know why not? Cells.Find(What:="[0-9].", ...
0
votes
1answer
23 views

VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...
0
votes
1answer
31 views

Excel VBA: Intersect methode with several names range [closed]

The Intersect don't work. Dim NTit As Range Dim NInf As Range Dim NDat As Range Dim WS As Worksheet Set WS = ActiveSheet Set NTit = WS.Range("$A$1:$J$1") Set NInf = ...
-1
votes
1answer
15 views

Where to put the Change Event Code

CHANGE EVENT: I have 12 sheets in a workbook. Do you have to put the Change Event in the 12 sheet, if not, where I must put the code for this event.
0
votes
1answer
59 views

How do I generate random numbers between a range in cells? [duplicate]

I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the ...
0
votes
0answers
18 views

Date FileDateTime in sharepoint

Sub Test() myURL = "http://sps.ap.emersonprocess.com/sg/pssops/svcops/APServicePortal/ChartTemplates/ Filename = "IBS-CCR-AP_Prod.xlsx" myURL = Replace(myURL, "http:", "") myURL = Replace(myURL, "/", ...
1
vote
1answer
54 views

EXCEL - How to use two cells for input and output at the same time [duplicate]

I have 3 cells, VALUE, DOWNPAYMENT, DOWNPAYMENT %. The 3rd cell "DOWNPAYMENT %" calculates the percentage of "DOWNPAYMENT" over "VALUE" Is there a way for the user to have the function to input a ...
0
votes
2answers
56 views

MS Access 2010 maximum number of records

I have VBA program written in Access 2010. It creates and populates a table from a text file. Previously, there have been less than 20,000 records total. With the current data set, I get an ...
0
votes
0answers
20 views

Which ODBC connection properties have higher priority ?

I take data from PostgreSQL via ODBC and put the data in excel worksheet. For this I use VBA which makes a query table. In the VBA script I specify a connection string which contains some ODBC ...
0
votes
1answer
60 views

How to control excel cells together with vba script?

In the userform there are product names (combobox) , prices , amount (textbox). For product name control I use with combobox . I write amount of product to my textbox as a manuel when I choose the ...
1
vote
1answer
110 views

How to add photos to specific cells in my Excel worksheet from my computer? [closed]

This is the code which I used : Private Sub Image1_Click() Range("C1").Select Application.Dialogs(xlDialogInsertPicture).Show End Sub Private Sub Image2_Click() Range("D1").Select ...
0
votes
0answers
42 views

Import/export conditional formatting rules in Excel 2013

Is there a way to import/export conditional formatting rules in Excel 2013? Possibly using VBA?
1
vote
3answers
31 views

Splitting Data in Excel Based on Character Location

I have a column of data, each row containing a set of 83 characters (e.g. 010203 344345 929348238482abcde33 4566) with no particular pattern that needs to be split into blocks of different lengths ...
0
votes
2answers
92 views

excel vba codes user form

I have created a user form for my work book. I would like the user to navigate their way around the workbook using the button on this user form. Is there any code that I can use to limit the user by ...
1
vote
1answer
74 views

excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform. Now I would like a button on the ...
0
votes
0answers
21 views

How to have excel 2007 userform stay on top of all other windows

The title says it all really. I have a modeless form generated in excel 2007 that'd ideally stay on top of all other windows (not just excel). I know other applications can set this, but I'm unsure ...
2
votes
1answer
54 views

Excel sheet with list of servers and links to different Remote Desktops

I have found some code to execute Remote Desktop from Excel, Sub RDP() Dim RetVal As Variant RetVal = Shell("c:\WIndows\System32\mstsc.exe " & Range("A1"), 1) End Sub I have many ...
0
votes
1answer
143 views

How do I create VBA code to extract certain columns of data from excel file? [closed]

I have a data file that has 600 columns and 14,000 rows of data. I am working on creating an excel GUI that lets you reduce this data to only the parameters you need. The parameters (headers) are in ...
1
vote
2answers
73 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 ...
0
votes
0answers
46 views

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

I have a large (over 10k rows) spreadsheet with text data I want to concatenate from multiple rows into a single row. The text data corresponds to a date that is in a merged cell in a neighboring ...
0
votes
1answer
25 views

Microsoft Powerpivot button not working

Hoping someone can assist me with this strange Powerpivot issue; I have a single workbook which is not working with Powerpivot. It has a substantial amount of VBA code (much of which is related to ...
0
votes
1answer
28 views

Outlook 2010 oft template Item_Send not firing

I have written a very simple Item_Send handler for an outlook mail message template stored as an oft file that I run via a Macro: Function Item_Send() MsgBox "hello" Item_Send = False End ...
-1
votes
2answers
37 views

Creating NEW files and folders

Sub Test() Dim myDir As String Dim Folder1 As String StartDate = DateValue("2-Nov-2014") NumberOfDays = 1 For N = 0 To NumberOfDays - 1 Folder1 = UCase(Format(StartDate + N, "MMM YYYY")) Folder2 = ...
1
vote
2answers
66 views

How can I make a Msgbox pop up over other application?

I have an Excel macro that deals with thousands of lines in several tables and do some copy/paste/analyze/combine... operations. it takes almost 10minutes to run it fully. I added a MsgBox "Job Done" ...
0
votes
1answer
67 views

How to create an Excel Macro that works with any Excel workbook on my computer?

I want to create a macro and save it in a way so that it would be used by any Excel workbook I open on my computer. Is there a way to do this?
2
votes
1answer
161 views

Application and Object Defined Runtime Error 1004 - using for loops to populate Cells(x, y)

I'm using the below code to try and find the intersect of Var1 and Var2, and populate the value into my userform that I'm running. I have no problem finding the intersect, but every time I try and ...
-1
votes
0answers
18 views

custom outlook reminder addin or VBA [duplicate]

I cannot count how many times I missed my meetings appointment because I Was so deep into my programming work. I wonder if anyone has a quick/easy solution where it will halt my entire monitor red (or ...
-2
votes
2answers
128 views

How to have a value from one Excel sheet propagate to other sheets, while being incremented?

I have an Excel workbook, which has 100 sheets in it, all the sheets are identical apart from A10 in every sheet. In A10 of sheet 1 there is a value 101 which I typed in manually and A10 of all other ...
-6
votes
2answers
99 views

How to do simple math in Excel VBA

I have a value in any cell which is greater than 60. For my purpose, I need to subtract 60 from such values until the value is less than 60. So, for example, say I have a cell containing a value of ...
2
votes
1answer
79 views

Word macro to change page color

I am attempting to create a Word macro (Microsoft Word Professional 10) to change the page background color. I began by recording the keystrokes - this is the recorded macro: --- Sub WritingLayout() ...
1
vote
1answer
59 views

Assistance with Excel macros

My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to it but don't have the first clue about how to do it. I'll do my ...
1
vote
1answer
95 views

VBA code to change the selection of a drop down list (combo box)? [closed]

I ran the macro recorder and changed the selection of a drop down list that is formatted with data validation, and nothing was recorded. Does this mean that there is no way in VBA to change the ...
0
votes
1answer
126 views

Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales. The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...
0
votes
1answer
41 views

Excel Macro To Highlight Every Row Above Every Empty Row

I have an excel data sheet which is divided into data blocks of variable number of rows. Data blocks are separated from each other with an empty row. What I am in a dire need for is a macro that ...
0
votes
2answers
71 views

How can I automatically fill a series in excel, based on the value of another cell?

How do I automatically change the length of a column with the numbers 0-n, where n = a number in a certain field? I'm thinking of something like this: EDIT: Seems like I was bad at explaining ...
2
votes
1answer
156 views

Outlook macro to remove text and insert signature

(Note: I've never messed with VBA before; sorry for probably terrible code!) I'm trying to make a macro that first removes paragraphs containing specific terms (hardcoded into the macro), then sets ...
1
vote
1answer
651 views

How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
1
vote
1answer
72 views

Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event. I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...
1
vote
2answers
5k views

Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...
0
votes
1answer
92 views

How To Autofill (Using VBA) Until Adjacent Cell Equals a Particular Value

I want to autofill a data validation list down in column E. However I want to stop the autofill when it reaches a particular value in an adjacent column (column B). For example, I have 50 rows in ...
0
votes
1answer
25 views

Is there a way to include “workbook” event functions in my personal macros file?

e.g. Private Sub Workbook_AfterSave(ByVal Success As Boolean) Beep End Sub This only works in "ThisWorkbook," and only in 1 spreadsheet at a time, not in my personal.xlsb file. (Inspired from ...
2
votes
1answer
43 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 ...
0
votes
0answers
28 views

When enter key is pressed, find the next instance of searched word

I have recorded the macro for the process of finding word. Whenever I hit enter button it will go to the next occurrence of searched word.How can I do it programatically using macros. When I click ...
1
vote
1answer
65 views

How to highlight multiple searched words in a document?

I have a file which has words to be searched in it. I want to highlight those words in active document. For example: style.docx: school Agro commercial abovementioned some words physics Active ...
1
vote
1answer
781 views

Populating Data Table in Word with Excel VBA: Selecting Range between two bookmarks and pasting

With Excel and Word 2013 & Windows 8: In essence, I have an excel template that I want to update to a word template. I have about 20 tables in Word, that are preformatted and I want to update ...
0
votes
0answers
68 views

Mouse Pointer Glitch when using Dual Monitors, Win 8.1, Excel 2013, and VBA, Visual Studio. Cursor Drifts

I have been using Windows 8.1 and Excel 2013 and I've been writing a lot of VB for Excel. Also I've been using Visual Studio 2013 on some projects I'm working on. I've searched for this answer and ...
2
votes
0answers
58 views

How can I sign an MS Word macro with a digital certificate from the local machine certificate store?

I am trying to find out how I can digitally sign a Microsoft Word macro using a valid 3rd party CA issued VBA code-signing certificate that is installed into the machine rather than the user ...