Showing related tags and posts accross the entire site.
Since I can’t install JPSoftwareTech’s Amazon link generator, I decided to write my own. Fewer features, less choice because that’s how I roll. I recommend JP’s version – it’s very well done. My tastes and habits are very quirky, so this “utility” is very...
If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries...
Hi Everyone, With Excel 2013 we also got new document windowing in Excel; Microsoft decided to make Excel behave the same as Word: from MDI: to SDI: This causes havoc when one shows a modeless userform which should stay on top of all Excel windows: I’ve devised a way to prevent this problem and...
Why do I keep creating userforms to get passwords? That’s it. This is the last time I’m doing it. From now on, I’ll just import UPassword.frm Here’s the code behind the form. Nothing special, I’m just tired of typing it.
Option Explicit Private mbUserCancel As Boolean
For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1051 Add userform items on the fly.shtml
Dick Kusleika’s VBE Find is useful enough that it justifies the resources need to enhance it.
In addition to adding Regular Expression searching (Adding functionality - I) a sort capability made sense since since the results include code from multiple code modules and procedures within them. The...
On many occasions there is a need to lay out controls horizontally in a userform so that they are equally spaced and, as a group, centered within the userform. An example is the group of three buttons (OK, Cancel, and Help) in the userform below.
The worksheet below calculates the left position of...
In Previous Sheets Stack, I created a historical list of sheets visited on the right click menu for easier navigation. After reading the comments, I decided to change the whole approach. Now I show related sheets (which I define) in a userform.
I'm dealing with inventory assemblies...
In my DDoE Quick TTC utility, I split text out into separate listbox columns. That means the column widths are always changing. Jan Karel has a very nice write-up on autosizing listbox columns. Based on that, I wrote the below procedure. I used the hidden label technique that JKP suggested. Instead...
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as...