Somewhere out of left field........

[DiscoPistol]

As someone who considers themselves more than competent with Excel/VBA, over the years the occasions when something has come out of left field and left me agog (great word) have become few and far between.

But today, whilst looking at some OLD company spreadsheets I came across DialogSheets for the first time. Tré Cool!

So when was the last thing that you guys found something that left you both open mouthed and with a inane geeky grin on your face?

 

[xld]

DialogSheets ... cool? In what way when you have VBA?

 

[DiscoPistol]

In a Nostalgic way. I'm not advocating there use in everyday life (and indeed am currently burning them all at the stake where I've found them)

 

[xld]

In a Nostalgic way. I'm not advocating there use in everyday life (and indeed am currently burning them all at the stake where I've found them)

LOL! Quite right too.

Having said what I said, and making no apologies, but I do sometimes use them to create a dynamic form, such as one that has a number of option buttons based upon a table, with a simple action basis.

 

[Richard Schollar]

I would place Roger Govier's method for turning a denormalised table into a normalised one using Pivot Table Multiple Consolidation Ranges - I would have sworn before the Excel User Conference that MCRs had exactly no actual use at all. Finding that in fact they do (and it's a pretty good one at that!) was something of a revelation!

 

[Patience]

Ah Richard. I had a mini mental orgasm at that part. Sublime and beautiful. Coulda saved me 6 months last year if I knew it before - but there's always next year.

 

[xld]

I would place Roger Govier's method for turning a denormalised table into a normalised one using Pivot Table Multiple Consolidation Ranges - I would have sworn before the Excel User Conference that MCRs had exactly no actual use at all. Finding that in fact they do (and it's a pretty good one at that!) was something of a revelation!

Yeah, but he stole my thunder. I had that as part of my visualisation presentation (and I had tons of spare time).

 

[SydneyGeek]

Sounds great -- so, how's it done?

Denis

 

[xld]

Is that directed at me?

 

[VoG]

In a Nostalgic way. I'm not advocating there use in everyday life (and indeed am currently burning them all at the stake where I've found them)

This may prove handy http://j-walk.com/ss/excel/files/dlgwiz.htm