Search:

Type: Posts; User: Transformer

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Reverse Geocoding: Get Location Address from GPS coordinates(Latitude & Longitude)

    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...
  2. Dynamically Highlight Data point on Your Chart Without VBA

    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...
  3. 2014 in review - Thank you All!! 2015 will be better, we promise...

    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...
  4. Replies
    0
    Views
    5,090

    Happy Holidays All... See You Next Year! (from everyone at Useful Gyaan)

    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
    ...
  5. Replies
    0
    Views
    3,884

    Introducing Our New Category... R

    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...
  6. Did You Know :: How to Hide Rows With No Data

    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...
  7. Replies
    0
    Views
    4,038

    Network relationship chart

    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...
  8. Trick of the Week :: Store (and then fetch) files from SQL Server tables

    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...
  9. You dont need to add fields in recordset, it can...

    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 & "]
  10. Custom Charts in Excel :: Comparing Series Against Average or Benchmark

    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...
  11. How To Create Interactive Charts in Excel Using Chart Events

    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...
  12. Did You Know ::: Automatic Subtotals (& More) :: Data List Outline

    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...
  13. Replies
    0
    Views
    4,695

    Large Operation Warning: Excel

    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...
  14. Opening URL @ new tab in Internet Explorer: VBA

    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...
  15. Replies
    0
    Views
    5,004

    The Ultimate Correlated SQL Query

    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...
  16. Custom Charts in Excel :: Gauge Chart (aka Dial/Speedometer Chart)

    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...
  17. Trick of the Week :: Custom Views For an Dashboard(Excel) Using VBA

    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...
  18. Trick of the Week :: Custom Views to Control Workbook Display Options

    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:...
  19. Replies
    16
    Views
    17,008

    You can check cells count. Private Sub...

    You can check cells count.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Cells.Count >= 2 Then Exit Sub
    Application.EnableEvents = False
    ...
  20. Conditional Formatting to Create Simple Gantt Chart for Project Plans

    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...
  21. How To Add Additional Metadata Hidden Information To A Workbook Or Worksheet

    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...
  22. VBA Trick of the Week:: Protect Worksheet for User Actions Only

    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...
  23. Replies
    1
    Views
    1,619

    You have used userform1_Initialize and...

    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...
  24. Did You Know :: Finding All Objects & Controlling Object Visibility Using Selection P

    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...
  25. How To Hide The Members of An Enum Statement In VBA

    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 ‘_’...
Results 1 to 25 of 91
Page 1 of 4 1 2 3 4