Timeline for Compact VBA Validator for Excel Names
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 21, 2022 at 9:03 | comment | added | Greg |
@Greedo I might have a workaround here! I call it "psuedoinvocation". It's somewhat unconventional, and almost certainly inefficient in the extreme, but it should make the .Names approach accessible to UDFs.
|
|
| Aug 1, 2022 at 22:57 | comment | added | Greg |
Thanks @MathieuGuindon, I'll definitely look into it! Every time I get a neat idea (like a hyperlink to trigger a #FileBrowser()) in Excel, it always requires a component (like a formula parser) that needs developing...and then that component requires a further component (like IsValidName()) that needs developing...and so on.
|
|
| Aug 1, 2022 at 21:23 | comment | added | Mathieu Guindon | This is a great review that deserves more votes! Thanks for testing things out (and wow, a whole 30% slower... in my defense it was a phone post haha!), and for bringing up Rubberduck! @Greg having written a good chunk of it I'm obviously biased, but there's a non-zero chance that Rubberduck changes your life as a VBA dev - enjoy! | |
| Jul 31, 2022 at 21:46 | history | edited | Greedo | CC BY-SA 4.0 |
added 117 characters in body
|
| Jul 31, 2022 at 19:33 | comment | added | Greg |
Wow, thank you for this in-depth examination, and also for the comparison in performance! Having learned that VBA has no short-circuiting, I always planned on breaking out the VBA.InStr(...) block into separate statements. Likewise, I always planned on defining a constant NAME_MAX_LENGTH. However, the Like operator is definitely news to me, and since my parser iterates heavily, I need every bit of speed I can get. As for the @Description tag, I love it! An R programmer by nurture, I find this welcomely familiar to @description.
|
|
| Jul 31, 2022 at 19:24 | history | edited | Greedo | CC BY-SA 4.0 |
added 630 characters in body
|
| Jul 31, 2022 at 19:06 | history | edited | Greedo | CC BY-SA 4.0 |
deleted 231 characters in body
|
| Jul 31, 2022 at 18:56 | history | edited | Greedo | CC BY-SA 4.0 |
deleted 231 characters in body
|
| Jul 31, 2022 at 18:19 | history | answered | Greedo | CC BY-SA 4.0 |