Its really frustrating.
I originally had 'DTPicker' in my workbook that is used to enter and track incidents for my company. But, there are a handful of machines that are 64bit, and I couldnt find any compliant date picker modules that would work... so I finally gave up and just have a simple textbox for entering the date. (so i just went back to the way it was before when it worked before I started using DTPicker (wouldnt work with 64bit), and then later when I tried using some date picker modules/code (which was supposed to be 64bit compliant but I never could get any of them to work) that is floating around on the internet... well wouldnt you know it... the same 64bit machines that had a problem with the code before STILL has a problem with it now too even after I remove the offending code. What I am missing??
After I open a userform and then click on my commandbutton to copy the data to the worksheet it gives me this error ("TRIM" function):
Then, after removing THAT offending code (note where I changed the previously 'bad' trim code to green) it just moves down to the very next piece of code and says it doesnt like that one now... and then I can do the same thing to it, and then it just moves down to the next line of code, and so on...
What gives? Is my workbook possessed by satan? Because before adding any of the DTPicker stuff this same code ran just fine. Now it doesn't.
Please and Thank you for any help so I can fix this devilish code once and for all.
I originally had 'DTPicker' in my workbook that is used to enter and track incidents for my company. But, there are a handful of machines that are 64bit, and I couldnt find any compliant date picker modules that would work... so I finally gave up and just have a simple textbox for entering the date. (so i just went back to the way it was before when it worked before I started using DTPicker (wouldnt work with 64bit), and then later when I tried using some date picker modules/code (which was supposed to be 64bit compliant but I never could get any of them to work) that is floating around on the internet... well wouldnt you know it... the same 64bit machines that had a problem with the code before STILL has a problem with it now too even after I remove the offending code. What I am missing??
After I open a userform and then click on my commandbutton to copy the data to the worksheet it gives me this error ("TRIM" function):
Then, after removing THAT offending code (note where I changed the previously 'bad' trim code to green) it just moves down to the very next piece of code and says it doesnt like that one now... and then I can do the same thing to it, and then it just moves down to the next line of code, and so on...
What gives? Is my workbook possessed by satan? Because before adding any of the DTPicker stuff this same code ran just fine. Now it doesn't.
Please and Thank you for any help so I can fix this devilish code once and for all.