Posted
by Gershwyn
on Stack Overflow
See other posts from Stack Overflow
or by Gershwyn
Published on 2010-04-15T15:20:04Z
Indexed on
2010/04/15
15:23 UTC
Read the original article
Hit count: 205
What is the simplest way in VBA to determine the size (i.e., number of keys) in a dictionary object?
© Stack Overflow or respective owner
as seen on Developper.com
- Search for 'Developper.com'
Bonjour à tous!
Voici un article sur la programmation des extensions OpenGL, en VB6/VBA
Cet article décrit l'utilisation de quelques extensions fréquemment utilisées :
- Les VBO (vertex buffer objects) pour améliorer les performances
- Les textures 3D pour réaliser des textures continue sur…
>>> More
as seen on Developper.com
- Search for 'Developper.com'
Bonjour,
Ci-dessous, le lien vers un nouveau tutoriel :
« Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox »
Le but de ce tutoriel est :
De présenter une bonne approche de la résolution d'un problème simple en VBA.
D'expliciter en…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello all,
I'm creating a spreadsheet to train my numerical skills.
Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying.
Is there a way that I can execute a…
>>> More
as seen on Super User
- Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA.
Here is an example of what I mean (I removed…
>>> More
as seen on Super User
- Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Trying to find out if a provided Type is of a given generic type (with any generic types inside)
Let me Explain:
bool IsOfGenericType(Type baseType, Type sampleType)
{
/// ...
}
Such that:
IsOfGenericType(typeof(Dictionary<,>), typeof(Dictionary<string, int>)); // True
IsOfGenericType(typeof(IDictionary<…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am looking to create a dictionary with 'roll-back' capabilities in python. The dictionary would start with a revision number of 0, and the revision would be bumped up only by explicit method call. I do not need to delete keys, only add and update key,value pairs, and then roll back. I will never…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a System.Collections.Generic.Dictionary<string, string> containing control ID and appropriate data column to data bind:
var dic = new Dictionary<string, string>
{
{ "Label1", "FooCount" },
{ "Label2", "BarCount" }
};
I use it that way:
var row = ((DataRowView)FormView1…
>>> More
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
Like I mentioned in this post a while back, I came across a dictionary web service called Aonaware that serves up word definitions from various dictionaries and is really easy to use. The services page on their website, http://services.aonaware.com/DictService/DictService.asmx, lists all the operations…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a piece of code with a) which I replaced with b) purely for legibility ...
a)
if ( WORD[ INDEX ] == 'A' ) branch = BRANCH.A;
/* B through to Y */
if ( WORD[ INDEX ] == 'Z' ) branch = BRANCH.Z;
b)
switch ( WORD[ INDEX ] ) {
case 'A' : branch = BRANCH.A; break;
/* B through to Y…
>>> More
