load

Sub LoadColsIntoArray() ' This code worked perfect with no problem EXCEPT as noted in ' the TEST SECTION at the end. Dim ws2 As Worksheet: Set ws2 = Sheets("Sheet2") Dim Ary2 As Variant Dim Ary2rows As Long Dim Cols As String Dim LastRow As Long...

Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...

I have this code here, to create qr code. It's doing well getting the code. But I am thinking of having a pre-created barcode control, where I only run the code to load the control instead of creating new one each time. Maybe, the sheet change event will do the job. But since this object is...

I have a data validation with a nested if statement. =IF(R8="D18",D18_OP,IF(R8="D24",D24_OP,IF($R$8="D34",D34_OP))) It works fine as long as I don't have D18 in R8. D18_OP named range = "Not Applicable". When D18 appears in R8 the drop down will not load with "Not Applicable" nor can I select...

I have a strange behaviour occurring whilst trying to load a Listbox on a Userform. I have the following code which populates the Listbox with data dependant on the value of column E: Private Sub UserForm_Initialize()Dim Rng As Range, Dn As Range, c As Long, Ray() Set Rng = Range(Range("A2")...

Cannot Define field more than once and The specification failed to execute. Try re-creating the specification I am simply trying to reload an excel file with the updated one, I've done it before no errors. I even removed the Auto Numbered ID and reran the load, same issue. if not this error...

Hi I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the name of the Dialog Box to load. strDialogBox="xlDialogFontProperties" Application.Dialogs(strDialogBox).Show How would I do this? I'd like to open...

I set listbox items to load picture in the picture box. Selecting an item in listbox is slow, the higher the size of the jpg file, the longer it takes to load, which do not give room to select another item quickly. is there any solution to this?

Hi, I have an excel file with 5 buttons and each of them has a separate vba module but I want to display only one button on load of an excel. Other 4 buttons should load on click of the fifth button which was visible. Can anybody please guide me how to get this thing done? Thank you

In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B)...

I have a DLL with I don't want to put it in the system folder. I do I let VBA, how do I load dll from the path I want?

Hi, recently started using Excel professional 2016. I am not getting option of pivot table report while loading data to excel. Can any body help. I am getting only two options:- 1. Load to Table Only Create Connection

I have a column of data in a worksheet and need to load that data into text boxes on a userform. I have done this in the past, however, I can’t get the code to work in this new situation. A sample of the worksheet data consists of the following: <tbody> Row Description Yes/No Distance 1...

Hi, I have a problem with loading data from a web-page with Power Query. I get an error message that it can't view data beause of Internet Explorer Compabiliy View. And when I try to load I don't get any content, just the html framework. Why is this?

Hello all, I've got several query pulling out unique subsets from my main data set. This is all in the same workbook. When I do my PQ, I always close & load to new sheet. But, I want the result to come into the new sheet down a few rows, like maybe in cell D1 or so. This leaves me room for...

Sub Tapcon_134() ' ' Add_Fastener Macro ' Sheets("Hardware Load List").Range("C" & Rows.Count).End(xlUp).Offset(1).Resize(, 6).Value = Range("B9,D9,E9:F9,G9:H9").Value End Sub The above macro is only taking the value is B9 and copying it across all cells in "Hardware Load list". I want to copy...

I'm using Microsoft Excel 2010 and had a few useful add-ins like flex find installed. https://www.jkp-ads.com/officemarketplaceff-en.asp.However, I do not use these add-ins frequently. Since it seems that Microsoft excel 2010 loads, these add-ins at start-up and it significantly increases the...

Hello again, I have a FORM that is used to select players/teams to play in a tournament, and then macros will generate brackets for the competition. The 'Yes' and 'No' cells also have radio buttons to select who will be playing during that round of competition. I have been unsuccessful at...

Hello again, I have a FORM that is used to select players/teams to play in a tournament, and then macros will generate brackets for the competition. On the FORM there are radio buttons before the 'Yes' and 'no' words. They are used to select who will be playing during that round of...

I have a couple of hundred rows that I want to vlookup and I have over 100 data tabels, when I change a combobox a couple of thousand formulas recalculate. And it takes a couple of seconds to recalculate and I am looking at ways to increase speed. Will it be faster do load every data table...