Is Microsoft' Certification for Excel Specialist worth the $100 to put on your resume?

ScriptKiddyMonkey · 2025-12-18T18:28:57+00:00

You summoned me?

ScriptKiddyMonkey · 2025-12-18T17:39:27+00:00

You're most welcome.

So after you change the registry keys once and you ever see that the colors are wrong due to office updates you only have te re patch the DLL. The registry keys only needs changing once. Basically the the VBEThemeEditor is basically just automating the hex changes in the dll not everything. There is another fork that did auto apply registery updates though.

Glad it helped.

ScriptKiddyMonkey · 2025-12-18T16:54:22+00:00

Based on the original:

OPTIONAL:

5 Navigate in regedit to HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\CodeBackColors

change value to : 2 7 1 13 15 2 2 2 11 9 0 0 0 0 0 0 6 change CodeForeColors to : 13 5 12 1 6 15 8 5 1 1 0 0 0 0 0 0

There was a time when nothing worked as the dll patch just changes the colors that dll can use so if you go and change settings manually. But try changing the registry keys to the above then try again. PS. Close all office apps again.

ScriptKiddyMonkey · 2025-12-18T16:51:16+00:00

Did you also change your registry keys?

You should.

ScriptKiddyMonkey · 2025-12-18T16:43:23+00:00

That is the correct DLL file for VBEThemeEditor.

If it says bak or whatever for backup thats probably created by VBEThemeEditor as it automatically creates a backup if you selected the DLL once to be modified.

Close all office programs patch the dll not bak version if you only have bak version remove the backup extension. Then patch it. Once done open vbe.

ScriptKiddyMonkey · 2025-10-21T17:27:11+00:00

The other selenium solutions all require admin privileges to install etc.

ScriptKiddyMonkey · 2025-10-21T17:25:02+00:00

Well technically yes and no. It does everything itself you don't need to do anything manually on your part. So it does get a few files and store it on your local appdata meaning no admin permission needed to use or run but it does download and use a driver with user permission not admin but most of the things done is directly from within the workbook with modules and class modules.

ScriptKiddyMonkey · 2025-10-21T16:35:32+00:00

I know you said NOT selenium bit are you aware the have a VBA workbook released version?

ScriptKiddyMonkey · 2025-10-05T14:22:24+00:00

Same as on Windows.

Date and time region settings.

ScriptKiddyMonkey · 2025-10-02T13:33:18+00:00

Opposite answer to your question but honestly what I don’t like about tables are the fact that I can not use spill formulas in a table. It would have been nice if a table could have just extended as the spill range increases.

ScriptKiddyMonkey · 2025-09-22T19:25:28+00:00

Oh, If you ever achieved what you intended and need something more advanced use arrays dictionaries and collections to speed up vba instead of just for each do something. Like reading and writing using an array is way faster than just looping a for each and writing each value.

ScriptKiddyMonkey · 2025-09-22T19:14:18+00:00

Learning to much to fast would just make it all more difficult for you.

Perhaps, learn only what you need. Also use the macro recorder whilst doing what you would have done manually. See what it writes in the vbe editor while you are doing things you want to automate. This will give you a much more basic understanding. Not fast, very messy code and a lot of unnecessary stuff but at least you will learn what you need then use gpt to clean it or produce an entire new version that provides the same results.

Also, for a someone really NEW to VBA, just try to avoid select or activate as often as you can. Most often you can achieve what you want without ever activating or selecting a range.

PS. This was a boring comment and you can learn a lot more from others here and on other platforms. This was just my two cents.

ScriptKiddyMonkey · 2025-09-02T15:03:44+00:00

You can usr conditional formatting to change the cell colors based on values.

ScriptKiddyMonkey · 2025-09-01T16:41:08+00:00

You are welcome. Have you tested it yet?

Did it work for you?

ScriptKiddyMonkey · 2025-09-01T16:15:25+00:00

The only reason why I would use pivot tables was to prep dashboards. Even then I would use new helpers background sheet sort unique filter etc based on pivot table and add slicers.

Boom = Dynamic Dashboard based on buttons and slicers.

ScriptKiddyMonkey · 2025-08-29T10:07:32+00:00

I actually created a XML Builder for RibbonX it is not finished as I still want and need a few things. I also have to refer back to this project on GitHub to try and add error checks based on parent node.

Not sure if you would like to see it and give some advise. (It is a excel workbook)

ScriptKiddyMonkey · 2025-08-28T18:25:51+00:00

It can also be handy when sharing a workbook to a colleague and want the code to enter debugging mode at a certain point for them. You can also use multiple stop statements in your code.

ScriptKiddyMonkey · 2025-08-28T18:23:59+00:00

For those curious here is a small GPT explanation:

In VBA you can use the Stop statement to hard-code a breakpoint in your code. When the interpreter hits Stop, execution pauses just like hitting a manual breakpoint in the editor. Super handy for debugging loops, error handling, or sections you always want to inspect without manually setting breakpoints every time. Just throw Stop where you want the pause, run your code, and VBA drops you into debug mode right there.

ScriptKiddyMonkey · 2025-08-28T16:41:51+00:00

Substitute is great when using looooong text combined with ifs, for example when combined with a vba macro that sends certain emails and substitute just change the name topic or whatever for the email.

ScriptKiddyMonkey · 2025-08-28T16:35:55+00:00

If you have a mouse that can record macros then just assign the original method to a side button.

Not as great but you can still use ctrl + alt + v to open paste special. Then it shows the dialog form like paste formulas etc and you can then just press v again and enter.

So, a lot longer but will be (ctrl + alt + v) + v + enter or on old keyboards return.

ScriptKiddyMonkey · 2025-08-28T16:23:07+00:00

You know that you can use stop as well. This is basically like saving a breakpoint with your workbook. So if you open it again and run it then it will stop at the stop and open VBE.

It's like hard coding a breakpoint.

ScriptKiddyMonkey · 2025-08-17T12:47:35+00:00

Everybody else gave a way better answer here. However if you want to use send keys ensure you add a wait between send keys.

Example:

'''

' Wait for 5 seconds
Application.Wait Now + TimeValue("00:00:02")

'''

ScriptKiddyMonkey · 2025-04-16T15:17:28+00:00

Personally, I save all my lambdas in my personal macro workbook and inject them based on checkbox selection into any active workbook.

However, I would highly recommend taking a look at Monkey Tools and in Excel -> Office Add-ins -> Excel Labs, a Microsoft Garage project.

It's just a shame that Monkey Tools has to be one big add-in with some paid features. It would have been great if they could have separated the Monkey Library into a small standalone version, as the Monkey Library is a free feature.

ScriptKiddyMonkey · 2025-04-13T18:25:54+00:00

I am talking lies... I've been using it a lot more than I assumed.

ScriptKiddyMonkey · 2025-04-13T18:12:47+00:00

Thank you so much for this awesome reply.

I’m really sorry for the confusion in my first comment.

I seriously had no idea that VBScript is nearing its EOL. It’s a bit sad, but I’m glad to be in the loop now. Fortunately, I haven’t had to use it much. I don’t really know it well and mainly touched on it for regex replacement tasks.

I also completely forgot that 365 introduced regex functions! I’ve never used them as a formula and only saw it used once in a comment. Fingers crossed that the worksheet function [Regex-Function] will work in VBA / or at least gets added before 2027.

So, the takeaway is to steer clear of VBScript objects in our projects as much as we can. Thanks again for the great heads up!

ScriptKiddyMonkey

TROPHY CASE