Tuesday, January 4, 2011

Shift Cell after enter data

This is the Excel VBA macro for me to shift from column one to column two after enter data, then from column two will switch to next row column one.

Basically column one is item code , we use bar code scanner , then column two will be number of quantity. After enter quantity , then the box will switch to next row and ready to read the next item.


Private Sub Worksheet_Change(ByVal Target As Range)

If ActiveCell.Column = 1 Then
ActiveCell.Offset(0, 1).Select
ElseIf ActiveCell.Column = 2 Then
ActiveCell.Offset(1, -1).Select
End If

End Sub



Monday, January 3, 2011

Run Linux Flash Player Projector in Fedora 14

If you plan to launch the Linux Flash Player Projector (Flash standalone player which allow you to view flash without launching the browser) from the Linux , this might be able to help you.

You're going to need a few additional packages:
sudo yum install libcurl.i686
sudo yum install libcurl-dev
sudo yum install libcurl
sudo yum install curl
sudo yum install libcanberra-gtk-module.so
sudo yum install libpk-gtk-module.so
sudo yum install libssl3.so
sudo yum install libgtk-x11-2.0.so.0
sudo yum install libfontconfig.so.1
sudo yum install libfreetype.so.6
sudo yum install libXt.so.6
sudo yum install libXext.so.6
sudo yum install libX11.so.6

Original article: