Following my previous question Create a table that lists macros in a workbook or worksheet here's my Sub to determine worksheet visibility in a workbook. This arises from updating code that used extremely hard to understand logic and several disparate NamedRanges to subsequently hide/reveal sheet...
huh, the Access Form Controls collection enumerates all of the controls, but you can also index into a Field - I guess that's how frm!FieldName works
so for a recordset with field names "Foo" and "Name", Foo is available as an extended member of the Form, but Name conflicts with the base property Name, so the only way to access the "Name" field is with Form!Name or Form.Controls("Name")
> This seems to work for ActiveX controls in the following hosts:
- Excel - Access - PowerPoint - Visio (Although selecting multiple controls seems to default the Properties window selection back to the designer/vbComponent, and the ComboBox is populated.
I have an Excel where i have file names in one column with the revision numbers in another column. I need to remove the duplicates(file with higher version should be retained and lowerversion deleted).Can you guys help me with excel VBA for this.
Eg Raw Data
Desired output from macro
What ...
@QuackExchange What do you guys think? It could be interpreted as "Help me extend my code's functionality" but I'm inclined to say it's complete andworking enough to be On-Topic.
While workable, I'm tempted to down vote (but haven't) simply because it's enabling bad questions. The OP didn't even post what he tried. — FreeMan9 secs ago
I just realized that the nifty new floating header on SO doesn't even have the help/tour links anymore!
am I missing something? Have they done away with that & I just didn't notice the conversation about it?
true, but I hit those regularly to copy the links for those who do need to read them. I know there are shortcuts that link to them, but who the heck remembers those???
> @comintern is it safe to assume that the path problem I noted here was resolved, despite my not posting an additional issues as @rubberduck203 requested?
@Comintern I remembered it as them pushing a button to end it - that wasn't the case, but because this is still a joyful article: grantland.com/hollywood-prospectus/…
I was going to joke that he only had seconds left to push the ask button
Also sadly, the video is no longer available, but there's tons of screenshots so you can skim through anyway.
> When I look at the content of these tests, any relationship to this PR is not obvious to me. The tests appear to be independent of code that was modified. I also ran these tests in loops. The results vary slightly with each run of the loops. However, the results below are typical:
EnclosingProjectComesBeforeOtherProceduralModule - Run Mode: succeeded 60 out of 100 tests - Debug Mode: succeeded 92 out of 100 tests
EnclosingProjectComesBeforeOtherModuleInEnclosingProject - Run Mode
> @BZngr Do not worry about the failed tests. These are three of our beloved six tests that fail an pass randomly for about two months now. We still have not figured out what is causing it but it must be some concurrency issue in the tests.
New user to RD with a tooltip display box question.
Under RubberDuck>Settings>Code Inspection Settings>Inspection Severities>Code Quality Issues The tooltip message is visible for about 5 seconds, is there a way to make it visible longer?
> FWIW - There is a simple way to mask the concurrency issue yet allow the tests to run and detect 'hard' failures. Just give the Parser several tries to get the right answer prior to evaluating the results within the Assert. The example below is for 'EnclosingProjectComesBeforeOtherProceduralModule':
for (int idx = 1; idx < 25 && declaration.References.Count() != 1; idx++) { state = Parse(vbe); declaration = state.AllUserDeclaration
@IvenBach It's in the very definition of the tooltip itself (found it here) - looks like the tooptip duration is left to whatever the WPF default is. That should be an easy thing to tweak, but yeah it would have to be done in Visual Studio
The indentation level is a completely different story, it's a full-fledged setting, configurable from the indenter settings page (or from the VBE's own options dialog)
@IvenBach what would you suggest the duration to be? Feel free to create a new issue on the project's repository for it :-)
Thanks. I'm new to VS and am ignorant of much that it can do/offer. I only have it installed at home and can't configure anything at work. I'll keep perusing RD and familiarizing myself. I have a lot to learn... Everything has me greatly impressed so far.
I'm not horribly familiar with tooltips in WPF, but the ideal UX would be to show the tooltip after a delay on hover, and then dismiss it when the mouse moves.
@BZngr The main problem with "passing" tests like that is that it isn't obvious from the test results what is broken and what needs attention. If a test is ignored, you can double click it in the test window and see the comment about why it's ignored.
@Mat'sMug I'm just glad that VBE actually has people that care about it. Wish everything RD is doing was native... There are so many people who use Excel that either don't know about OOP or can't devote the time to make the switch. I hope to at some point bring some positive contribution and look forward to new updates.
In this case, we know there's a problem with either the test or some underlying concurrency thing - the goal is to simply get them out of the way of AppVeyor. I couldn't care less if they fail in my local build.
snake-game is a game where you control a snake in an enclosed square without running into the walls or your own body. The snake grows when you run into whatever item you are supposed to run into.
My snake eats mice:
You can get it to play from github and hopefully it will work
Sadly, this s...
@Comintern I'll probably let Rubberduck bully me into better names once 2.0.12 comes out, but in the meantime I use meaningless names for reusable variables. What would you prefer I call them? :P
Probably doesn't help because it still violates the self-contained code principle, but if it makes you feel any better, in my declarations I have them split into fixed-use and reusable sections, with separate naming conventions for each, and I won't reuse a variable outside of its code block. But I can see how that could be perceived as kind of a bastard, no-one-but-you-will-know halfway worst of both worlds thing.
@puzzlepiece87 it's actually quite rewarding to take a rather large piece of code, and trim it so much that it ends up doing exactly the same thing with half the code
2
(and I don't mean renaming all variables to single-character names!)
Yeah, about the only issue is that the properties window has to be visible. Are they going through the message pump for the MDI parent or the child hack?
@Comintern (joking) remind me to keep a backup copy of any code I write in notepad, I think our company AV is going to delete my memory mapping attempt ha
It gets angry when I've used kernel functions to change the system list separator though I thankfully got it to work eventually.
Nah, I'd be a bit more worried about setting a LL keyboard hook. :-)
Thanks for your help! I was able to get it to work. Also, I was completely ignorant to the Hungarian notation. That being said, 'iRow' and 'iCol' were defined as 'Long', but I will update the code to comply with naming standards. I'll post my updated code. — kschindl35 secs ago
According to naming convention variable names would be camelCase. Is that the correct term? Does this hold true if there the variable is a single word (IE: delimit) or would Delimit be preferred?
What's nice about the VBE, though, is that once you Dim theDelimiter As... you can type thedelimiter and it will fix it for you. I use that as a spell check when I'm typing those nice, long, descriptive variable names.
Also, what is the difference between an auto-property and a field in C#? I can't find any semantical differences, other than internally, it uses a method to assign, rather than directly assigning.
@Mat'sMug @FreeMan Mouse over the editing toolbar and see what other useful stuff pops up. Thats why I want to be able to have tooltips persist fro more than 5 seconds. I read everything...
@Comintern yep static variables and procedure variables maintain their values. There are some edge cases where that is useful. But it's a hard edge to find.
@ThunderFrame Finding a good use for static local variables in VBA is already difficult, but the modifier making all local variables in the procedure static is plain confusing.
@IvenBach I'm very much a keyboard guy myself, which is one of the reasons I hate the new Ribbon - it's very difficult to get the keyboard shortcuts for them. I just never took the time to look at all those options and realize what they all did for me.
@FreeMan I had a co-worker ask me a couple months ago and finally took the time to understand them, glad I did and you can get some use out of it. I feel if I ever have to take my hands off the keyboard, when using Excel, to use the mouse then somethings wrong, terribly wrong...
It irritates me that the extra formatting options that appear when you right-click the mouse are not there when you hit the right-click button on the keyboard. >:(
> OK, I'll say it. There is no good use case for these. This...
``` Static Sub Foo() Dim bar As Long bar = bar + 1 Debug.Print bar End Sub ``` ...should almost always be written as... ``` Sub Foo() Static bar As Long bar = bar + 1 Debug.Print bar End Sub ``` This should be at least a suggestion level inspection - it's just too easy to introduce bugs by adding additional variables (think loop counter) into `Static` procedures. The quickfix would explic
@Comintern Those particular messages don't pump through anywhere else. That doesn't mean that other useful messages aren't flowing, but I don't think any other messages carry details of the selection or context.
@ThunderFrame In Excel itself, not the VBE. For some reason I can't upload an image right now, but in Excel, right click on a cell - there's a horizontal menu that is the key items from Format Cells. If you hit the Right-click button on your keyboard, that doesn't show up, just the vertical menu
On most desktop keyboards (PC, not Mac focused) there is a Windows key between the left Ctrl & Alt keys, and a Right-Click or Context Menu key between the right Ctrl & Alt keys.
I have an Excel where i have file names in one column with the revision numbers in another column. I need to remove the duplicates(file with higher version should be retained and lowerversion deleted).Can you guys help me with excel VBA for this.
Eg Raw Data
Desired output from macro
What ...
snake-game is a game where you control a snake in an enclosed square without running into the walls or your own body. The snake grows when you run into whatever item you are supposed to run into.
My snake eats mice:
You can get it to play from github and hopefully it will work
Sadly, this s...
VBA Rubberducking
VBA Rubberducking