1. kelly mort

    Load images from separate folders

    Hi, This code is giving me a headache and I need someone fix it for me. Currently both controls are loading the image from same folder "Picture1". I want the second control to load from "picture2". I have tried some stuffs but the script keeps laughing at me:laugh: . Private Sub...
  2. P

    VBA Loop

    Hi, I am trying to calculate the optimal way to load containers. I have the current amount of fuel in each container and I have the amount of fuel I know will burn in aggregate prior to reaching my terminus where I will refuel the containers. I can choose which container I burn fuel from. I...
  3. kelly mort

    Remove comma from a textbox

    Private Sub lstView_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim n As Integer, ac As Integer, i As Integer i = Me.lstView.ListIndex With lstView For ac = 1 To .ColumnCount .TextColumn = ac Me.Controls("Rw" & ac).Value = .Text Next ac...
  4. kelly mort

    Load filtered data to listbox instead of worksheet

    Hello, I want to find out if this code below here can be made to load the data into a listbox instead of pasting it to the sheet. My knowledge is limited with the how. Thanks in advance. Sub FilterDates() Dim rCrit As Range Sheets("HOME").UsedRange.ClearContents With...
  5. Z

    Load UserForm InkPicture with Ink saved in Excel worksheet

    Hello, I have struck out all day trying to find an answer to my problem. I would really appreciate any assistance that you can offer. I have a UserForm with an InkPicture that I am using for approval signatures. Long story short, I have been able to save the ink strokes to the active Excel...
  6. H

    new issue- trouble with "Load frmFormName"

    So has there been a recent Excel update that would cause the vba code saying "Load frmFormName" to now cause this error: "Run-time error '380': Could not set the List property. Invalid property value." Using this same command worked for 2 years, and now all of the sudden it fails... any help...
  7. I

    Create a button to load a excell file then process it

    Hi guys I need to load an Excel file with a button, then process and modify it and change it to txt or pdf after the changes. Can I do this with VBA?any body can help me plz? :)
  8. E

    Vlookup comment with image

    Hi, I've tried searching for this online and can't find exactly what I need. What code can I use to have my comment and image load from column H on the second sheet into the first sheet when typing in the corresponding lookup value. https://imgur.com/a/bIdWfai
  9. P

    Power Query takes 25 minutes to load: Am I setting this up correctly or should I make a change to imporove load time.

    I have the following queries set up: 1) FY131415 (357,000 rows) 2) FY151617 (6,146,235 rows) 3) AllFY (6,503,415 rows) This is just a combination of query 1 and 2 It takes a total of about 25 minutes to load this power query workbook and the data is updated daily so I need to update...
  10. Z

    Excel Table sorting after Data Load refreshing

    Hi, I have SQL connection that load data into Excel Table. I have set sorting criteria in that table (Excel Table, not SQL query) so my question is: Will this sorting still be valid after data load refreshing??
  11. M

    Search for Value in Excel Return Yes or No Based on Multiple Criteria

    Hello! I have 2 reports that are on separate sheets, 1 & 2. Both contain a load id # and I would like to enter a formula on Sheet 1 that tells me whether or not that load id # is on sheet 2, returning either a yes or no value. To achieve this, I have the following formula...
  12. P

    The requested operation cannot be performed on a file with a user-mapped section open...

    I am trying to load access data into excel but I am getting an error message that says: The requested operation cannot be performed on a file with a user-mapped section open... Does anyone know what I need to do in order to be able to load the data to the data model. Here is the message: The...
  13. F

    Help with Unique IDs - Find and remove duplicates and replace

    I have very basic user Excel knowledge. I have a spreadsheet where I keep track of reloading data. Each load I enter gets a unique load number that is calculated automatically with a formula, based on the caliber name and a incrementally increasing number. As of now, every load I enter gets a...
  14. F

    Excel VBA Copy row to another sheet based on cell value

    I have basic Excel knowledge and very little VBA. I have a spreadsheet where I keep all my reloading data. I keep all this data in a master sheet and add new loads to this sheet as needed. I reload multiple calibers and would like to sort each caliber to its own specific sheet with a macro...
  15. L

    How to bring picture in front in VBA

    Hello... I'm using Excel 2010 and I have an issue with some pictures. I load some pictures with the below code and I want to remove a specific one or bring in front the other one. The problem is that any time I load a picture the excel name is different and I dont know a way to find that name to...
  16. L

    cleaning file samples

    Hi Where can I find excel files which has raw data need to be cleaned/formatted etc, remove duplicate, blank cells etc. I want to practice that on real life files. Is there any website I can down load these files from? Thank you very much.
  17. J

    DatePicker will not load on machine

    I'm writing a macro with a date picker but it won't load on the machine that I'm testing it on. I'm using 2007 on both machines. On the test machine, I noticed there is only the Office12 folder in the installation folder. On the machine I'm working on, there are several folders. I downloaded the...
  18. O

    How to do iteration calculation using VBA in Excel

    I am making a model of Electric vehicle load on electric grid. I was using formulas to calculates things but now what i need to do will not be possible with formulas. I have not worked with VBA before so have no idea how to do it. if someone can help, it will be great. I have attached a part of...
  19. J

    How To load a Excel File (a Macro) when Excel is Opened?

    hi all. my question is: How To load a Excel File (a Macro) when Excel is Opened? i want load a custom Ribbon, always and i think is the uniqe way... i am reading: http://www.rondebruin.nl/win/s2/win001.htm Any ideas? thanks
  20. N

    Load Planning

    Hello, I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other...

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