byval

  1. A

    VBA Scatter Plot Hover Label

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

    Setting cursor to the end of the text in a textbox also when entering with a mouseclick

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

    Sleep API conversion 32 / 64 bit

    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)...
  4. C

    Excel VBA - Closing a specific File Explorer window out of multiple open File Explorer windows

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

    Temporarily mute sound (like snooze button) if VBA wave file (alarm) is playing

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

    VBA FTP file download doesn't work on 64bit machines

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

    Smartview for Excel

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

    vba assistance

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

    VBAProject properties prompting for password when protection is not enabled

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

    VBScript - Show only Userform - Userfrom does not apear "In Front"

    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...
  11. Jaafar Tribak

    Trigger MouseMove Event on Deselected Charts ?

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

    Should Worksheets And Ranges Be Passed ByVal Or ByRef?

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

    Search & Copy function based on criteria that EXCLUDES invalid entries

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

    Search & Copy function based on criteria that EXCLUDES invalid entries

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

    Upgraded Excel to 2013 now code doesnt work

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

    Adding time filter to existing VBA code

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

    Perfecting Mousemove event for dynamically created labels

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

    Timeline slicer on protected sheet (Years, Quarters, Months, Days)

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top