It can work for this purpose but fails if you want a variable amount of numbers before the decimal. However, I know how much you hate large pieces of code so I doubt you'll use it
I'll see if I can make an adjustment for currency values.
It can work for this purpose but fails if you want a variable amount of numbers before the decimal. However, I know how much you hate large pieces of code so I doubt you'll use it
I'll see if I can make an adjustment for currency values.
You are right, I doubt I'll use it as it was a silly comment on your part. 3 smileys for you
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
Fangbeast wrote:I want a properly formatted, masked string gadget
such as I used to use in early versions of visual basic. I used it back in
the early days of vb.
This isn't a gadget, but here is code I posted in May 2004 about
something similar (updated for PB 4.00). Sparkie was involved in that
topic too
Maybe you will find a useable idea here, before all the brain matter leaks
out the eye sockets.
[/code]
Terry you old bugger, still hiding around the forums I see!! Arr, good to see your stuff. Your date picker code got me started years ago and it's still damned useful.
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
It can work for this purpose but fails if you want a variable amount of numbers before the decimal. However, I know how much you hate large pieces of code so I doubt you'll use it
I'll see if I can make an adjustment for currency values.
If you are still reading this post, try to adjust a few things first please, unless the code is generic to masks and not specific to currency (I think I made a silly comment myself there (grin))
1. Don't allow the cursor to go before the "$" symbol.
2. Make the field mask len char "#" invisible, it doesn't need to be seen I think. Not sure how excel does it as I haven't got it.
3. Check if the user pressed the "." and jump after the decimal point.
Should you choose not to accept this mission mr spock, the message will self destruct in 10 seconds.
Good work by the way.
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
You guys crack me up. But I'm still sending a bunch of feral, lobotimsed hamsters with laser gun scopes to take you out for those cracks!!
And listen here Netmaestro, you haven't passed the old geezer test yet so I'm not sure you are allowed to use my copyright name of "Fanglized", certified by the old geezers association.
Now Sparkie I can vouch for, he passed with flying colours (Evil Grin(c) 2007))
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
I was born at/before punchcards (I think). Doesn't change the fact that you have to pass the geezer test, send me some martian dollars, assorted loose women (And they have to be loose because the tight ones kill me) and 3 witnesses must sign.
Relatives, friends and pad off third parties may not sign!!!
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet