UsefulGyaan Has Posted the Following On 07-05-2015 10:06 PM:
Reverse geocoding is the process of taking a set of GPS coordinates and turning it into the nearest available address. Browsing through...
Type: Posts; User: Transformer
UsefulGyaan Has Posted the Following On 07-05-2015 10:06 PM:
Reverse geocoding is the process of taking a set of GPS coordinates and turning it into the nearest available address. Browsing through...
UsefulGyaan Has Posted the Following On 01-06-2015 07:53 AM:
It's no secret that I'm a big fan of beautiful data visualizations. What may not be so obvious is that I'm huge on the KISS (keep it...
UsefulGyaan Has Posted the Following On 12-30-2014 06:52 PM:
The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney...
UsefulGyaan Has Posted the Following On 12-26-2014 01:46 PM:
Filed under: Othershttp://pixel.wp.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542&post=1528&subd=usefulgyaan&ref=&feed=1
...
UsefulGyaan Has Posted the Following On 12-01-2014 01:39 PM:
You know how learning new things keeps one’s mind agile (or so I’ve heard). Well, following this adage, I’ve recently been spending...
UsefulGyaan Has Posted the Following On 11-11-2014 02:08 PM:
We have earlier discussed how to hide errors in a worksheet in this post. Today I’m going address another similar problem that is very...
UsefulGyaan Has Posted the Following On 11-06-2014 01:50 PM:
Originally posted on User Friendly:
I’m a big fan of anyone who can display data in a visual way. *Well today, rather than displaying...
UsefulGyaan Has Posted the Following On 09-30-2014 06:55 PM:
Problem Statement: I have a database of employees where I store information about each person. I wish to have a picture of the employee...
You dont need to add fields in recordset, it can be achieved easily by making changes in your query.
e.g. SELECT A, B,C, Right(A,2) as D, mid(A,3,4) as E FROM [" & sFileName & "]
...
UsefulGyaan Has Posted the Following On 04-18-2014 10:23 PM:
This is a common requirement while creating dashboards. One selects an option and the charts update to show data for that particular...
UsefulGyaan Has Posted the Following On 04-15-2014 09:26 PM:
In my experience I have come across numerous people who so wish that their charts are ‘Interactive’. I’m sure many of you would like to...
UsefulGyaan Has Posted the Following On 09-23-2013 03:31 PM:
When working with a hierarchical data, most often we need to view at various levels of hierarchy. One of the ways of getting it done is...
UsefulGyaan Has Posted the Following On 09-12-2013 09:18 PM:
We generally see a “Warning Dialogue Box” like: This is seen when we try to put a formula, value or formatting to a big range (many...
UsefulGyaan Has Posted the Following On 09-11-2013 08:50 PM:
Problem Statement:*Suppose, we have an array of URLs and we need to open them one by one. By looping over all the URLs on the same tab...
UsefulGyaan Has Posted the Following On 08-23-2013 09:22 PM:
Problem Statement:* There is a table named SkillSet which has employees’ skill details. We need to find out employees (skill wise) who...
UsefulGyaan Has Posted the Following On 08-07-2013 05:45 PM:
Although this is not my personal favorite chart, I have seen that many people find it fabulous since it looks good on a dashboard. I...
UsefulGyaan Has Posted the Following On 07-31-2013 02:51 PM:
While Preparing an Excel Dashboard one needs to handle a lot of hiding and unhiding of Sheets for various users. For Devloper all...
UsefulGyaan Has Posted the Following On 07-31-2013 03:53 PM:
When your Excel dashboard has multiple users, you might want to customise the options available to different sets of users. Scenario 1:...
You can check cells count.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count >= 2 Then Exit Sub
Application.EnableEvents = False
...
UsefulGyaan Has Posted the Following On 07-30-2013 07:02 AM:
There are numerous Project Management tools available in the market which make life easier while managing huge projects. But for...
UsefulGyaan Has Posted the Following On 07-29-2013 01:20 PM:
Want to keep some information a bit out of reach of the user or you want to keep some information for your code support away from...
UsefulGyaan Has Posted the Following On 07-24-2013 10:15 AM:
We protect a worksheet so that it can not be modified and this protection applies to VBA operations and user actions both. Some VBA...
You have used userform1_Initialize and userform2_Initialize procedures to add items to Combobox2 and combobox3 but you didn't call them anywhere. Either write that code in UserForm_Initialize...
UsefulGyaan Has Posted the Following On 07-22-2013 10:02 AM:
Scenario 1 When we build dashboards in Excel, we add many objects on the worksheet. We may choose to hide some of these or make them...
UsefulGyaan Has Posted the Following On 07-19-2013 09:31 AM:
If you want to prevent a member of Enum from being displayed in VB editor’s intellisense then it can be done by prefixing them with ‘_’...