andrewsw's Profile User Rating: *****

Reputation: 4231 Guru
Group:
Mentors
Active Posts:
15,639 (18.05 per day)
Joined:
12-December 12
Profile Views:
120,298
Last Active:
User is offline Today, 01:08 PM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
3275
Expert In:
VB.Net/VB6
Icon   andrewsw Giggity, Giggity, Goo!

Blog entries

andrewsw's Blog > Excel with Andy: Dynamic Drop-Down

Posted 04 April 2015

Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...

Read Full Entry →

andrewsw's Blog > Excel with Andy: More Functions

Posted 26 March 2015

Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...

Read Full Entry →

andrewsw's Blog > RSS Feed in WPF

Posted 18 February 2015

I found this cool page to display RSS feed items in WPF:

Build an RSS reader in 5 minutes

It works great. I thought I would see how it behaves with dream.in.code's feed:

http://feeds.feedbur...ured?format=xml

Image reduced in size

Unfortunately it, for me, produces a Script Error dialog several times. My settings in IE are already set to not...

Read Full Entry →

andrewsw's Blog > Dipping Into F#

Posted 04 February 2015

If you don't have access to a full version of Visual Studio it is now easier to dip your toe into the F# waters, and functional programming, by downloading the free Visual Studio Community 2013 edition...

Read Full Entry →

andrewsw's Blog > Grand Unified Snippet

Posted 24 January 2015

When I first encountered Sublime Text, a few years ago now, I was first attracted to the look of it, then by multi-line editing, but mainly by the possibility of using it as a vehicle to extend my knowledge of Python. Python is the main language behind its plug-in architecture. On further investigation I noticed that regex...

Read Full Entry →

My Information

Member Title:
I'm not here to twist your niblets
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  2. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  3. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  4. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  5. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  6. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  7. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  8. Photo

    Michael26 Icon

    27 May 2013 - 16:14
    Great for you andrew, keep up the good work :)
  9. Photo

    jon.kiparsky Icon

    15 May 2013 - 13:13
    Jinx, buy me a coke!
  10. Photo

    laytonsdad Icon

    29 Mar 2013 - 14:15
    You are awesome.
  11. Photo

    kai_itz me Icon

    19 Mar 2013 - 23:10
    superb keep going....
  12. Photo

    _HAWK_ Icon

    04 Mar 2013 - 23:18
    Diggin on your Avatar man!
  13. Photo

    raghav.naganathan Icon

    26 Feb 2013 - 03:05
    Congrats on the 500 Mr.Enlightened :)
  14. Photo

    lar3ry Icon

    11 Feb 2013 - 05:50
    Very helpful answer on converting a string to an HtmlDocument! That one gets immediate use for me.
  15. Photo

    raghav.naganathan Icon

    11 Feb 2013 - 04:34
    Congrats on the 400 :) Excellent answer indeed!!! :)
  • (2 Pages)
  • +
  • 1
  • 2