Tips for Excel VBA

In a small Excel document, the input data need to be validated before saving. That is why a VBA code is needed. I hope this can also be done using formula, but a short VBA code look more sophisticated.

Firstly, Target is a range variable where the just input data located, it is a cell, generally. Secondly, I need to autofill or change some cells according to the new input data, I have to call the subroutine from the Change event, but, of cause, we can not modify the cell directly, otherwise, it will call such subroutine continously into a endless loop. What we need is inserting the code between
Application.EnableEvents = False
....
Application.EnableEvents = True

Finnally, to check if a cell is empty or not can be done by built-in function IsEmpty().

08 端午

一糯一菰一角黍，
一羹一箸一望乡。
屈子无意随波去，
我辈怎可妄退耕。

Forecastfox™ 0.9.7.5 bug in status bar

With the new update of great extension Forecastfox for Firefox, there is a bug in status bar, error message is:

_______<label
id="ff-load-label" value="&ff.preview.loading.label;"/>

----------^

In order to sovle it, one need to do the following (Original from Forecastfox office support forum)

• Close firefox.

• Go to C:\Documents and Settings\[your user name]\Application Data\Mozilla\Firefox\Profiles\[some random string].default\extensions

• view the folder in detaild mode and order by change date. Open the last changed folder.. Which probably is the forecastfox's folder...

• Open the chrome folder..

• open the forecastfox.jar with winrar...

• Goto locale and select the language your using under forecastfox folder you will find forecastfox.dtd extract it and add
  
  

  <!ENTITY ff.preview.loading.label
"Loading...">

Forecastfox™ 0.9.7.5 bug in status bar

With the new update of great extension Forecastfox for Firefox, there is a bug in status bar, error message is:

_______
----------^

In order to sovle it, one need to do the following (Original from Forecastfox office support forum)

• Close firefox.

• Go to C:\Documents and Settings\[your user name]\Application Data\Mozilla\Firefox\Profiles\[some random string].default\extensions

• view the folder in detaild mode and order by change date. Open the last changed folder.. Which probably is the forecastfox's folder...

• Open the chrome folder..

• open the forecastfox.jar with winrar...

• Goto locale and select the language your using under forecastfox folder you will find forecastfox.dtd extract it and add