longptr

I am trying to make a 32 bit code work into a 64 bit pc under this link, some of my files ... , there is a zip file named LeastSquareFitting.zip, Follow instructions and unzip file in your directory, then i saved as xlsb the existing minimizeLeastSquare workbook, I did some research, and the...

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

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

Running EXCEL 2016 16.0.9126.2282 64-bit on Windows 10 I have an Excel App that uses VBA to run external program and capture the output and it worked fine on Excel 32-bit. I had to update the program to work with Win64/VBA7 but now the call to GetStartupInfo crashes Excel. I have tried...

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

this code is design to enable scrolling with the mouse wheel in excel comboboxes placed on a worksheet(not userforms) written by: Jaafar Tribak for some reason this code only works on some computers the computers this code didnt work in are: win 10 office 2016 64bit win 7 office 2013 32bit...

I am running a subroutine on two 64bit machines both with Excel 2016 yet on one my program crashes entire Excel at launch with no error message. Here is the code (other code follows but it has to happen here). Any ideas? Thanks Option Compare Text 'ignore text case Option Explicit 'Object...

Can someone please check if the following API conversion, taken from here: Excel: Declaring API functions in 64 bit Office is correct? #If VBA7 Then #If Win64 Then Private Declare PtrSafe Function SetWindowLongPtr Lib "USER32" Alias "SetWindowLongPtrA" (ByVal hWnd As...