1. K

    Pivot, load https in drill down results

    Hello all! I have a pivot table that has an https address in the raw data, which appears in the drill down results. It looks like: + Supervisor name ....+ Representative name ........+ https:// All this appears in the same column, of course. I've found so many VBA's online that "should" load...
  2. A

    Combobox fill data = rngFind.Offset

    <colgroup><col span="2"></colgroup><tbody> column Z column AA A A01 B A02 C A03 D A04 A05 A06 A07 A08 A09 A10 B01 B02 B03 B04 B05 B06 B07 B08 B09 B10 C1 C2 C3 C4 C5 D1 D2 D3 D4 D5 </tbody> Good Day, Column Z...
  3. J

    Run Time 91 error on load

    Hi all I have a file that I run an SQL connection to a database on load. Whenever the file opens, I get the Run Time 91 error on load - Object variable or With block variable not set. Yet I can end the macro and re-run it without any further error. Private Sub Workbook_Open() Call Load_Sap...
  4. O

    distribution of time values randomly in a table

    Actually I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values, these time values can vary in number and depend on total number of cars. So e.g. total number of cars are 40...
  5. O

    Distributing value automatically across cells

    i have line load in column B, but the line in capped to 100 kW so the load more than 100 kW should be shifted to the cells where the load is less than hundred (can be seen in column D). from the table, we see the accumulated load to be shifted is 25 kW. this should be shifted to the cells...
  6. J

    VBA Yes/no msg box will only do the yes option

    Ok this is probably a simple fix but I just can't see it. I have a Yes/No msg box with the below code. The problem is if you click Yes OR No it follows the No instructions. Can someone please help me figure out what is wrong? Private Sub CommandButtonContinue_Click() Msg = "Scope...
  7. sharky12345

    Add items to Listbox based on criteria

    I'm using this to load a Listbox on a Userform as the form is loaded; ListBox4.RowSource = Range(Sheet5.Range("U2"), Sheet5.Range("U11").End(xlUp)).Address(, , , True) I now need to take this a step further if possible - I now need to load only those values where the value of the 2nd offset...
  8. J

    VBA: Load Data from another Workbook but avoid triggering its Workbook_Open Macros ?

    Hi, i have this VBA script to load data from another sheet but the sheets i load from contain Workbook_Open macros. Whenever i run the script the macro is triggered Is there a way to prevent this? My code below loads up file explorer, i click on my source workbook and it opens Msgbox pops up...
  9. Richard U

    Hiding and unhiding buttons in "add ins" on ribbon

    I've used the commandbar to create and remove buttons.... Sub AddNewCB() Dim myCommandBar As CommandBar, myCommandBarCtl As CommandBarControl On Error GoTo AddNewCB_Err Set myCommandBar = CommandBars.Add(Name:="MY_LIST", Position:=msoBarFloating, MenuBar:=False, Temporary:=True)...
  10. F

    Power Query Load data into Workbook but split onto different worksheets

    Does anyone know if it is possible to have your data and then when you load it back into the workbook it breaks the information down based on a column value? The only way I can see to do is to reference the original data and select each location manually for each new query. but I will have...
  11. ebea

    Image load

    Hi! A problem, loading pictures into an image form. I use the image on a UserForm, together with Textboxes, which are loaded by the following code: But I can't get the images to load as wanted. I have set image name for all rows, into Column O (in this case). I get the error message "Path not...
  12. R

    Macro/VBA could not load - not available.

    Good day, I am a bit of a neophyte but can follow most times. Right now the issue...I have a home budget program that works on every computer I own also those at work, but it does not work on my laptop. The error message I keep getting is "Could not load an object because it is not available on...
  13. kelly mort

    Listbox column heads

    Hello, Is there a way to load only the column heads of a listbox with vba code? I already have a script to load the listbox Just wondering if I can do the above Thanks
  14. N

    Userform Combobox

    Hello All, I have a userform with a combobox that on Initialize the combobox is loaded with about 23000+ items I have a checkbox where it will remove all of them currently 1 by 1 and load another list of only about 200 items When the checkbox is unchecked it will reverse it by removing the...
  15. J

    Load txt file into sheet on Open?

    Hi, unsure how to do this from a Txt file In the following format Name,Country Jim Jones,Australia Bob Frank,UK Want it to load into my sheet "Users" and overwrite current contents. Any help appreciated
  16. E

    Syntax Error for Load Me()

    Hello, I got fairly easy problem one of you may know the answer too. I just couldn't figure out. I have a userform, when its triggered, text boxes get populated. The data in the text boxes are coming from cell values in another sheet. However when I execute my Macro in the other sheet where...
  17. S

    Delete only selected pictures in Excel worksheet

    I'm using a VBA macro to load 15 pictures in various positions in an Excel worksheet. I'll examine those pictures, delete them, then load some more. The process repeats hundreds of times. This works fine if I want to delete all the pictures that I load. However, I'd like to add some shapes...
  18. M

    Load an Userform

    Good morning everyone: I have to develop a piece of code that calls an useform form two different places. The first one piece of code needs to load an UserForm in memory, so what I doing now if load the UserForm calling forma normal module this way: UFPAR.PPRUE Where UFPAR is the UserForm and...
  19. B

    3D Map 2016 Excel

    Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...
  20. D

    load Folder and Files into .Docx

    How to create raw word Application then load Folder and Files ? Public Sub creatdocx() Dim NewWord Dim NewDoc Dim CXP As CustomXMLPart Path = ThisWorkbook.Path & "\" DocPath = Path & "Word.docx" SrcPath = Path & "root" Set NewWord = CreateObject("word.Application") 'creating Word application...

Some videos you may like

This Week's Hot Topics