Tagged Questions

0
votes
2answers
38 views

Array of dynamic texboxes

In the form, everytime I click te button, a new textbox has to appear. I want to make an Array with all of these textboxes. The problem is, that al these textboxes have a dynamic name. How do I have ...
0
votes
2answers
42 views

Pasting array values and pasting normally

I've been having issues with this VBA program today, it has been working great for a couple of days and now its kicking up a stink. I hav.nt changed anything that I am aware of to cause this problem ...
0
votes
2answers
244 views

Excel VBA FormulaArray Too Slow

I have a macro that populates start and complete dates based upon the accounting period. For example: Product X has sales in Jan12 - Dec12. The macro would use a vlookup/min array to find the start ...
0
votes
1answer
1k views

VBA Excel Store Range as Array, extract cell values for formula. Offset for other variables

I'm a bit new at this. How would I take the column and put the cell data of which is an integer and go through all values in that range to put it into a function to output the result into another ...
0
votes
1answer
85 views

Finding non specific values from an array in another array in Excel Vba

Ok I have done alot of researching on this topic and I havent been able to find an answer so here it goes: I have data that I am receiving in an order that is undesirable (just columns with headings ...
0
votes
1answer
221 views

How to place contents of Excel rows into arrays based on condition

I have an excel sheet that I need to loop through each row and if it meets certain criteria, the data is placed into one of several different arrays. The number of rows are dynamic. I am ...
0
votes
1answer
87 views

Save as syntax and range.select index syntax?

I'm trying to write some lines of codes that select a range in excel but the index to the range has a syntax error any suggestions? Also I'm trying to save a XML file as an xlsm file with file names ...
0
votes
1answer
526 views

VBA two dimensional arrays connecting to a database

I am working with vba in excel and a database in access. The access database is a table that contains 3 columns; OrderIDs which is a column of numbers saying what order the particular item was in, ...
1
vote
0answers
172 views

How do i process 2 filter criterias in XML Parsing and sort using Excel VBA

i have question seeking advise from experts. Let's say i have these 2 filter criterias where node with attribute name = "XVECTOR" and name ="SOLVER_PRIORITY" will be selected from a bunch of XML ...
0
votes
0answers
38 views

Applying a function to an array and returning it to an excel worksheet

I'm working with an area (7,2) on an excel sheet trying to test a function. So, this code works, but it seems to me that it does not apply the procedure for each COLUMN as I wanted, but instead, it ...
0
votes
0answers
69 views

Using an Array to Input Formulas - Runs slow on large data set

I have created a macro that inputs sumif formulas into a spreadsheet in order to create a 'working' was-is file. Once the macro has been run and the formulas have been input the end user will update ...
0
votes
0answers
31 views

How to take out values from arrays and assign it to variable in excel vba

root(i) (having 3 roots) Now I have to take out only 1 value which is greater than 0 and feed that into one variable. I have written this code - For i = 1 To nRoots If root(i) > 0 Then ...
0
votes
0answers
358 views

Searching and operating on 2D array in excel vba

I´m working with Excel VBA and originally had a table with columns: DepartureLocation ArrivalLocation DistanceBetweenLocations This table is stored in a two dimensional Array(1 To Nr. of Rows in ...