byval

I saw this article by Vincent Tang which is a macro to download and rename images. The TL;DR being the name you want in column A & the image url/type in column B. I am currently using Excel 2016 64 bit and it seems to not be functioning properly. I was wondering if anyone could help me get this...

Can anyone tell what the prob might be. Getting compile error on start up. Used to work fine. Then they upgraded to Windows 10. I suspect a 32/64 bit confliction. Any suggestions? Thanks Option ExplicitPrivate Declare Function ShowWindow _ Lib "user32" _ (ByVal hwnd As Long, _ ByVal nCmdShow...

Morning, I have the following code written up for me but I cant seem to get this to work. I have Outlook 2016 64 bit, i require all my invoices to be printed either as they come in or late in the afternoon (4:30pm) I have a rule that will move these invoices to the invoice folder and run the...

I use osk.exe on my tablet when using a combobox. If I close the on-screen keyboard application in the midst of typing in the combobox, the combobox gets buggy. I can open the on-screen keyboard again but it will not show what I am typing in the combobox. I open the osk.exe application by...

I have a code that determines if a window is open or not based on input. It works well for all other programs, but for some reason does not detect when osk.exe is running... Any ideas? I basically put anything into the msgbox in my code between the quotation marks and it will search for a...

I got osk.exe to open but would rather utilize TabTip.exe instead. Any ideas on how this may be achieved? My code for bringing up the osk.exe is shown below. Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal lpszOp As String, ByVal...

Hi. Looking for guidance on how to use mousemove event on a multipage? Im trying to have a image as a button, and hover over changes colour. Below code works for a userform mousemove, but can find a solution when over a multipage instead Thanks Sub ExitButtonInactive_MouseMove(ByVal Button...

Hi All - I have the below code, which works fine, however it stops running when it hits an empty cell - I need this to run whether the cell has a url or not...(some of the cells are blank or don't have a URL yet... So I need it to run from D10:D1000 regardless. Can someone help me with the code...

Hello folks I wrote the code below, unfortunately, it works half the time. It's supposed to download some documents from a sharepoint site and save them. Sometimes it gets downloaded, sometimes it does not. I can't tell why. I would like to insert a code snippet where I can see what is...

Dears, I would like to kindly ask you for your help regards VBA code. Issue: I'm having very simple data entry form (kind of attendance list / evidence). I need to upgrade this code - currently data inserted to form are stored in different sheet of same excel file. I need to also save entered...

Hi! I am having a hard time getting this code running properly. I have searched the net for many hours. I want a standard module that will detect if the mouse wheel is scrolled up or down. Essentially, I am trying to change how many rows get scrolled at a time. Here is the code I have...

I have been on the web for a while now looking for solutions to my problems. I came a bit closer yet I am stacked trying to complete the next steps: Private Declare Function CreateIC Lib "gdi32" Alias "CreateICA" _ (ByVal lpDriverName As String, ByVal lpDeviceName As...

How do I convert this to work on 64 bit machines (as well as continuing on 32 bit as it is now...). Thanks Option Explicit Enum W32_Window_State Show_Normal = 1 Show_Minimized = 2 Show_Maximized = 3 Show_Min_No_Active = 7 Show_Default = 10 End Enum Private Declare...

I have this piece of code that I've used from someone else on here. One problem....It works for 32bit systems but not 64. How would I "convert" this to work on both? Thanks Option Explicit Enum W32_Window_State Show_Normal = 1 Show_Minimized = 2 Show_Maximized = 3...

Upon mouse hovering, the combobox will automatically drop down the list. Upon mouse leaving region of combobox, the list will automatically scroll up. The first task can be done using combobox.dropdown. However, how to handle second task? Any ideas? Private Sub ComboBox1_MouseMove(ByVal...

Hi, I recently found an excellent post by Jaafar Tribak on scrolling down ComboBox drop downs with the mouse wheel. I've tried running the following code. This is the code attached to my ComboBox (CombBox9): Option Explicit Private Sub ComboBox9_MouseMove(ByVal Button As Integer, ByVal Shift...

Hello, I found the below code on a KutTools guide and modified it a bit to suit my needs: #If VBA7 And Win64 Then Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _ ByVal hwnd As LongPtr, ByVal lpOperation As String, _...

I have a ComboBox ActiveX on Excel. 1.　When the mouse hovers over it, the comboBox will drop down. 2.　When the mouse leaves the region of ComboBox, the comboBox will collapse. Task 1 can be done using "MouseMove" event. However, for task 2, it seems that Excel VBA itself doesn't have...

So a gentleman on here made this piece of code, to be called within a macro, that eliminates the warning when opening URLs. Could this be tweaked so that when forcing excel to send an email (second code below), the warning for excel sending an email on your behalf was hidden? thanks! Option...

Hello I hope someone one can help: I want to try and achieve a code that will allow the Main volume to stay at Max but turn the Wave Input Volume (Sound from a website/Spotify etc) within the Mixer down individually when I play a sound through Excel. The code I have only turns down the...