byval

Hey, I'm just a beginner when it comes to using VBA code so I wondering if anyone could help me out I have a Scatter graph with a lot of points on it and I want to clean it up my making the data labels only appear when they are clicked on or hovered over. I found this after a bit of...

This is not a question, but demo of a method that works and is simple. When checking for methods to set the cursor to a particular position in a textbox, you will see the method: Private Sub Textbox1_Enter() Textbox1.SelStart = 5 End sub for instance to set the cursor after the 5th...

I want to find a conversion for the Sleep API. Should it be: #If VBA7 Then ' Excel 2010 or later Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal Milliseconds As LongPtr) #Else ' Excel 2007 or earlier Public Declare Sub Sleep Lib "kernel32" (ByVal Milliseconds As Long)...

Cell A3 contains folder path. Cells below contain file names with extensions. Upon selecting a cell below, my Excel macro opens that file's location in File Explorer and out of multiple files in that folder selects this particular one, which can be seen in Preview. When next cell containing...

Hi, I am using the below code to play a .wav file which acts like a wake up alarm. The .wav file is 8 mins long so that I definitely wake up. But while the alarm/.wav is playing I would like to be able to mute the sound for 30 seconds if the spacebar is pressed (so that I have time to wake up...

Hello, I'm having some problems regarding the editing and making the code to compile and work successfully on 64-bit Versions https://www.jkp-ads.com/articles/apideclarations.asp -> I've followed the differences of the code using the site here were each declaration can be saw on both...

I am trying to set up a file to auto log into Hypersion. Declare Function HypConnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtUserName As Variant, ByVal vtPassword As Variant, ByVal vtFriendlyName As Variant) As Long Declare Function HypCreateConnection Lib "HsAddin" (ByVal...

hi the following code works wonders although before creating a blank new sheet for pasting the screen grab it brings the wrong date and time. what amendment is required to ensure the exact current time date is changed before the screen copy to paste in a new sheet this is the code:- Option...

Recently, I had a project password go corrupt (still not sure how, literally a case of one day the password worked, the next day it didn't) and I had to use a macro-based workaround to re-establish access in VBA. During this process, I disabled the protection as the excel tool I created wasn't...

I am using a VBScript to launch an excel file with the application hidden so that only the userform appears and the application never shows (not even a flash as is typically seen with Application.Visible = False use). Everything works fine, the script opens open and hides the application then...

Hi all, As you know, worksheet embedded Charts have a MouseMove event which is fired when the mouse is moved over the active, or selected, chart (The event does not fire if the chart is not selected) This is so messy and counter-intuitive and can cause a number of issues specially screen...

Hi, I need some clarity on whether it makes more sense to pass objects such as worksheets and ranges ByVal or ByRef. When it comes to simple data types the answer is clear. If you change the value of a variable in the called procedure and want that change to be passed back to the CALLER then...

Alright so I'm a good portion of the way through this, but I can't seem to solve one issue. The function is intended to search a defined column for a defined criteria and copy the whole row if it's found. The issue is that, in addition to copying the rows with the criteria, it also copies...

Alright so I feel like I'm 90% there... there's one particular problem in the routine. Ultimately, I'm trying to increment through a dataset of 7000+ rows, search a defined column for a defined criteria, and then copy the entire row to a new sheet if that criteria is true within the searched...

Hi All, I just upgraded to Excel 2013 and now am getting an error saying I need to update my code to allow for 64bit. I tried changing to Declare PtrSafe Function but that didn't help. Any help is appreciated. The code that is generating the error is: <code> Private Declare Function...

Hi, I have VBA code that "knows" how to take several txt files from one folder and combine them to one excel sheet. I need your help to modify the code that it will take files only from the last week (last 7 days). How can I do it? Thanks! Code: Option Explicit #If VBA7 Then Private...

I have created 1000s of labels at runtime and I want to add a hover effect to them. The labels are originally designed as a white background and when you hover should go light grey and when clicked go dark grey. If you are not hovered over it anymore it should go back to its original color...

This is one of the most bizarre issue with Timeline slicers. It has existed ever since Timeline slicer exist (incl. Ms Excel 2013 and 2016). I have searched for solutions, none of which I found suitable. So here is mine: Problem: You have a timeline slicer, when the sheet is protected, it works...