| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jan | Mar » | |||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | |||||
This bolg was down for a few days last week. I have no idea why, I dont think it was because of hits! I basically I think it was a hosting issue - I’m waiting to hear back from my hosts. I hope this does not become a regular event. Sorry to anyone who tried […]
This is cool.
The ones I have watched have been good, it’s a nice way to learn/recap on some intresting subjects. Be sure to check out the following:
http://webcast.berkeley.edu/courses/archive.php?seriesid=1906978270
http://webcast.berkeley.edu/courses/archive.php?seriesid=1906978271
http://webcast.berkeley.edu/courses/archive.php?seriesid=1906978272
via MarkWielgus.com
Here is some simple code to combine a selction of formulas into one cell. I have not tested it very much so it's not guaranteed. It will also add a few extra (), than might be needed.
Sub CombineFormulas()
Dim objCell As Object
Dim sTemp As String
Dim sOperator As String
Dim rOutPut As range
On Error GoTo errorhandel
sOperator = InputBox("Operator [...]
I produced a .php file for VBA. I got most of the "Keywords" from ostrosoft.com, and added a few myself. I also changed the colour system. The VBA file has abou 160 "keywords" vs about 300 for the VB one. This is beacuse the "keywords" are infact "Bluewords", that is to say the [...]
Ok so this is a lazy post, but has anyone used the timer with double type?
Try it, I'm looking into this and hope to get a better understanding of the whole thing, but it seems to use 3 decimal places when loading the time, and more when subtacting (more sdp than singles). In documention it [...]
I was flicking through John's recently opened Hard Core XL VBA site (well forum), theres a lot of content there, it's a nice way to store a lot of code. One thing that i had never seen before was the go sub method
Basically you goto a Lable, excute whatever code follows and finish with a [...]
UPDATE:
Check Out Andy Popes code, a much better method of moving a userform with out a caption:
Here is some code to move the form around without the need for API coding.
Create a couple of private variables in the userform to remember the position when the left mouse button is pressed.
Private m_sngX as single
Private m_sngY as [...]
This is funny! i got 8 out of 10
In the past the beat experiences have been free, and quite good :-), sign up now, you've got nothing to lose!!!!
The new generation of Microsoft Windows© and Office© is about to be launched. Get in on the act right from the start and follow the new products as they go through to the finals. As [...]
Now updated:
http://www.blog.methodsinexcel.co.uk/2006/05/02/excel-front-loader-v2/
Last night I jumped onto the .Net train. So I’m a little late?
I’m using VB 2005 express. I knocked up a little “front loader” app. Very simple, it makes a new excel instance and loads a .xls file called “App.xls” from the same dir into that excel instance then exits.
I had a number of [...]
Microsoft are offering up quite a lot of decent resource for.net developers/or cross over developers. The Visual Studio Learning home page has a lot of links to virtual labs each aimed at different parts of VS. There are even a few books that can be downloaded for free! (sroll the learning home page or, just [...]
wow, VB 2005 express is free, but for a mere 25'000 dollars you can get your hands on this bad boy! Amazingly, no takers as yet..
This year the Excel users conference is coming to the uk (london). It should have course been held in Northampton - it beeing the centre of England and all that ;-).
Anyway it's a 2 day event, the second day being more advanced that the first.
The list of speakers is quite impressive (unconfirmed):
Patrick O'Beirne
Bob Phillips
Nick [...]