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

-1
votes
0answers
12 views

Vba Excel to click a browser link not working

I made a Macro that successfully logs in to my company's website, however I cannot navigate through the rest of links. After loggin in, the addres becomes ...
-2
votes
1answer
26 views

Excel VBA copy value to new

I'm brand new to VBA and macros. I've been stumbling along rather decently, but I've come across this problem and I'm not sure how to tweak the code. I need the user to be able to enter a value ...
0
votes
0answers
24 views

Access 2007. Make each string in text box clickable?

Access 2007. Database table tblUsers, column tblUsers.fldItems. That column can contain nothing, one word or a delimited list of items (brush, comb, sprocket). In a form I have a text box ...
0
votes
1answer
17 views

Intersect ERROR:Method 'Range' of object '_Global' failed

Why A get this error: Method 'Range' of object '_Global' failed When I Put: Private Sub Workbook_SheetChange(ByVal WS As Object, ByVal Target As Range) Dim NTT As Range Set WS = ActiveSheet Set NTT = ...
0
votes
1answer
13 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
14 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
19 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
10 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
11 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
18 views

Excel VBA: Intersect methode with several names range [on hold]

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 = ...
0
votes
1answer
14 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
38 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
53 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
0
votes
0answers
11 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
20 views

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

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 ...
-1
votes
0answers
12 views

Word VBA to insert Relative Hyperlinks [closed]

I'm looking for VBA macro to do the following: Search a document identified as CM1010 and find the following three types of document references to insert a relative hyperlinks for the following: ...
0
votes
0answers
22 views

Split Text String VBA [closed]

I need to split some text in Excel. I need to split the data but I cannot just use white space because I do not want to split some of the data (e.g., name and address). Is there a way to split based ...
0
votes
0answers
14 views

Update links to another excel workbooks

I have a excel work books that I use VBA programmed macros to open serval another workbooks (WB's). In the main WB I have a lot fomulas that is linked to the another WB's. After open all files, I ...
0
votes
2answers
32 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
11 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
54 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
81 views

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

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
23 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
24 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 ...
-2
votes
0answers
17 views

Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have? I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...
0
votes
2answers
53 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
48 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
16 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
44 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
75 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
60 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
33 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
0answers
15 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
24 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
35 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
45 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
55 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
73 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
104 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
72 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
53 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
51 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
65 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
71 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
36 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
50 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
0answers
52 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
203 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
53 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 ...