load

  1. M

    Power Query not loading data - Stalling

    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...
  2. kelly mort

    QR code to load a static barcode control on a worksheet

    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...
  3. E

    Data Validation - error

    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...
  4. sharky12345

    Listbox dates not formatted correctly

    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")...
  5. S

    Annoying Error When Trying to Reload Excel Database

    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...
  6. H

    BuiltIn Dialog Boxes

    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...
  7. Y

    Listbox selection slow

    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?
  8. M

    Button show hide on load of excel

    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
  9. K

    Need to Combine Rows

    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)...
  10. Y

    Load a custom DLL programmatically from another path

    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?
  11. W

    Query Load to -Option of Pivot table report not coming

    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
  12. Nitehawkhp

    Load data from worksheet into Userform

    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...
  13. S

    Internet Compatibility mode

    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?
  14. H

    Power Query Result to specific location on other sheet?

    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...
  15. W

    VBA macro for copying cells from one sheet and pasting to another

    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...
  16. W

    How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    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...
  17. Nitehawkhp

    Load FORM with data from Excel worksheet

    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...
  18. Nitehawkhp

    Load player names into FORM automatically

    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...
  19. W

    Load multiple data tables into arrays and using vlookup on the arrays for speed improvement

    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...
  20. T

    How do I insert non-adjacent columns into an array?

    Hello all you MrExcel experts I have a sheet with 26 columns and approximately 250,000 rows of data. The number of columns will stay the same, however, the number of rows will increase. I will be comparing data in columns 'B, D, N, Q', and depending of the results of that comparison, some...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top