Hi,
This is my first thread post, I've looking for a solution for what I'm going to ask, for the past couple of days and can't find any so I figured I should post it hoping that I get some help..
What I'm doing: I created a userform, it's pretty complex and runs perfect on my bosses and my computer (we both use Windows7 and Excel 2007).
What I need: however, I need this userform to run in another computer (uses Windows 8).
Problem: the VBA code runs just fine, but it doesn't format the the values in TextBox's to "Standard" numbers instead of currency.
PLEASE NOTE: that the code for formatting a TextBox general value to "Standard" number works perfect on it's own, BUT when I need to format TextBox "Currency" value to "Standard" number doesn't work...it doesn't change it back to number, instead it stays in currency format.
KNOWING THAT I DON'T GET THIS PROBLEM ON M COMPUTER OR MY BOSS'S COMPUTER.
I've checked the "Microsoft data formatting object library" and it's not missing from the references.
Can someone please explain and help on this, since I'm running out of time, I need to get it to work on this other computer.
This is my first thread post, I've looking for a solution for what I'm going to ask, for the past couple of days and can't find any so I figured I should post it hoping that I get some help..
What I'm doing: I created a userform, it's pretty complex and runs perfect on my bosses and my computer (we both use Windows7 and Excel 2007).
What I need: however, I need this userform to run in another computer (uses Windows 8).
Problem: the VBA code runs just fine, but it doesn't format the the values in TextBox's to "Standard" numbers instead of currency.
PLEASE NOTE: that the code for formatting a TextBox general value to "Standard" number works perfect on it's own, BUT when I need to format TextBox "Currency" value to "Standard" number doesn't work...it doesn't change it back to number, instead it stays in currency format.
KNOWING THAT I DON'T GET THIS PROBLEM ON M COMPUTER OR MY BOSS'S COMPUTER.
I've checked the "Microsoft data formatting object library" and it's not missing from the references.
Can someone please explain and help on this, since I'm running out of time, I need to get it to work on this other computer.