i need a "universal" variable, to pass values from an activex DLL made in VB6, and my application, made in excel VBA. is there a way?
specifically, i have written a progress bar in my DLL, and i call and update its progress from within VBA. but i have a cancel button in the progressbar form in the DLL. i need that if i click it, the DLL form will return a StopProcedure that could be read by a loop in my VBA application. ideas?