Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
0
votes
0answers
2 views
How to apply a formula down a column for several columns
I would like to autofill several columns with a formula. Since the columns are evenly spaced, I'd like to use a loop to accomplish this. How can I alter the following code to loop through filling ...
0
votes
1answer
5 views
Dynamic Destination Workbook for Excel VBA
I am trying to make a macro which Copies the Commission Calculation Tables into my Dental Commissions Report. The issue is that I have a fixed name "June Dental Commissions v5.xlsm" in the ...
0
votes
0answers
5 views
Allow third-party cookies for explorer
I'm working with VisualBasic + Asp.Net
Basically, the thing is that I have a parent-site with a lot of links to another sites.
My parent site is www.mydomain.com, each child-site has an own domain ...
0
votes
0answers
6 views
Combinatorics: Need to formulate and list combinations from multiple arrays to display mapping output
I have a mapping program that maps versioned language-codes from one version to another. The program maps the codes correctly with one caveat, working with combination codes. I have parsed the mapping ...
1
vote
2answers
28 views
Pass variables into VLOOKUP in VBA
I have this code:
currName = "string" 'unused
cellNum = [VLOOKUP("string", '2012'!A:M, 13, FALSE)]
But I need to replace "string" with a variable in the VBA code named currName. I tried this:
...
0
votes
1answer
17 views
Excel Put Array Value in Range - Transpose Gives Type Mismatch Error
I'm trying to assign an array of values to my Excel worksheet. When I use the TRANSPOSE function I am getting type mismatch errors. I don't understand why, there are only about 200 "rows" in the ...
0
votes
1answer
6 views
VBA Tree/Hierarchy
I am attempting to use Excel to fill in the blank cells in an organisational hierarchy I have. Before and After scenarios below.
I have attempted pseudocode on this.
For all rows
For all cells ...
-2
votes
0answers
18 views
Create language selection to launch application from CD [on hold]
I have a series of different language versions of the same .exe application and I would like to create a CD with an autorun file that will show a page from which I can select the language of choice ...
0
votes
1answer
17 views
Using a Parameterized Query on a SQL Table in Excel using VBA
I have some code that is supposed to run a parameterized query of the SQL table that I am query. The way that it does this is there is a designated cell (Z1) that is supposed to take in an input value ...
0
votes
1answer
18 views
Pointing to this object vba syntax
I have two class modules. Say class1 and class2. I want to set one of class2's properties to be class1 from within class 1. I know in java you can do something like
Class1{
Set Class2Object= ...
-2
votes
0answers
22 views
Using a combobox to pass parameter in a query in access
I'm trying to run a query that gets data from a table based on the criteria in a combo box on my main form. However despite setting up the query and linking it to the relevant combobox using ...
-3
votes
0answers
27 views
Converting Monthly to Quarterly Data in VBA
I am looking to write a code that will take an array of monthly data and convert it to quarterly by taking the average of every three data points (12 months in a year; 3 months in a quarter). I am ...
-2
votes
0answers
10 views
Add mobile number to label
I'm trying to add a mobile number to a label. Is that possible to do from a Visual Basic (2010 Express) Windows Form Application?
What I'm trying to do is make a really simple program that will let ...
-1
votes
2answers
38 views
What does “<>” mean in a SUMIFS statement?
I have a conditional sum statement:
=SUMIFS('11d. D&E LA - WEW Scroll'!$S:$S,'11d. DD&E LA - WEW Scroll'!$E:$E,"<>"&"LR",'11d. DD&E LA - WEW Scroll'!$D: ...
but no idea what ...
0
votes
1answer
21 views
Dynamic range not pasting correctly in Excel VBA
I have a workbook with two worksheets on it. Worksheet "Sheet2" has the new months data and worksheet "Audit scores" is the sheet that I am copying the data to. The code I wrote is suppose to check ...
