Troubled Bitcoin exchange Mt. Gox disappeared from the Internet last month and subsequently filed for bankruptcy protection in Tokyo, causing panic among users who feared that they had lost all their Bitcoins – but now Mt. Gox is finally letting users log in to check their wallet balances (via Engadget). However, it comes with a disclaimer that confirming the balance on the site doesn’t equate to a filing or any confirmation of rehabilitation claims — essentially warning users that they may not necessarily get back all the Bitcoins they have. Under the civil rehabilitation procedure that Mt. Gox is currently subscribed to,…
After taking the wraps off its latest flagship smartphone last month, LG announced today the start of sales of the G Pro 2 in Asian markets including Hong Kong, Taiwan, Singapore, the Philippines, Vietnam and Indonesia. Specific prices will be announced in individual markets, but in Singapore for example, the G Pro 2 is retailing at S$828 ($655) unlocked. The G Pro 2 looks pretty much like its predecessor — the G Pro. With a 5.9-inch full HD display, it is slightly larger than the G Pro’s 5.5-inches. It comes with the latest Android 4.4 (KitKat) operating system, is powered by a…
The people of Vancouver got their very own eye candy Monday, in the form of a humongous, glistening interactive art installation—called Unnumbered Sparks—floating high above the waterfront near the Convention Center. Constructed with featherweight fibers, the sculpture is anchored to the roof of a nearby skyscraper. No, it was not to celebrate St. Patrick’s day, but rather to commemorate the 30th anniversary of the TED Conference, which takes place in that city through March 21. The interactive part is a unique form of artistic crowdsharing—the installation also incorporates a giant Chrome browser window that spans the 300-foot sculpture via five high-definition projectors. Unnumbered…
As the biggest video sharing site by a landslide, YouTube attracts people from all walks of life, for better or for worse. Yet the Google-owned company is reportedly developing a version of the site for kids under 10 years old, and has even gauged the interest of video producers willing to create child-oriented content, according to multiple sources cited by The Information. The goal would be to offer a site that parents could trust, free of both videos and comments that many adults would prefer children not see. Parents could, for example, access a special app on a device or…
You all know that I love keyboard shortcuts. There is a limit, though. Some of my custom shortcuts clear the Undo stack, which can be a real pain, so I have to balance the productivity gains of the shortcut against the side effects. Back in January, I wanted to see which shortcuts I’d been using, so I created some code to keep track. The code is below, but first the results.
No surprise to me, pasting special – values tops the list. I paste values by default unless I need to paste something else. I should really just hijack Ctrl+V. If you’re wondering why the count for this one is so low in the first two-week period, it’s because I have severely ingrained muscle memory with Alt+E+S+V to show the Paste Special dialog and select the Values option. I wasn’t really using Ctrl+Shift+V, the shortcut assigned to this macro. I made an effort to use in early February. I’m not sure if I’ve ever posted this code before, so it’s high time.
Sub CopyPasteValues()
gclsAppEvents.AddLog "^+v", "CopyPasteValues"
If TypeName(Selection) = "Range"And Application.CutCopyMode = xlCopy Then
Selection.PasteSpecial xlPasteValuesAndNumberFormats ElseIf Application.CutCopyMode = xlCut Then IfNot ActiveSheet IsNothingThen
ActiveSheet.Paste EndIf EndIf
EndSub
You can see that I like to paste the values with the number formats.
I can’t find where I ever posted my FillVirtualScreen, CopySum, or GetMappedAddress code, so I guess I should do that in a future post. I was surprised that ShowFormatting wasn’t higher. Also, I thought DecrementDate would have been more used that IncrementDate. And FillSeries only seven times in two months?
To keep track of all this, I created a CLog class and a CLogs class. CLog has LogID, DateTime, Keys, and ProcName getter/setter properties. CLogs is a typical parent class with one exception I’ll show in a bit. In my App class, I added an AddLog and WriteLog procedure.