Thursday, March 25, 2010

Microsoft excel macro to compare two column for each row and highlight cell with condition

This Macro was tested with Microsoft Excel 2007.
Sub compare()
' Select first line of data.
Range("B2").Select
' Set Do loop to stop at empty cell.
Do Until IsEmpty(ActiveCell)
' Check active cell for search value.
If ActiveCell.Value = Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 3
ElseIf ActiveCell.Value > Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 4
ElseIf ActiveCell.Value < Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 5
Else
ActiveCell.Interior.ColorIndex = 6
End If
' Step down 1 row from present location.
ActiveCell.Offset(1, 0).Select
Loop
End Sub

Every time you change a value in the cell , you have to run the macro manually. In order to run it automatically, put the script into the Worksheet_Change function. (This code was not tested , just for reference.)
Private Sub Worksheet_Change(ByVal Target As Range)
' Select first line of data.
Range("B2").Select
' Set Do loop to stop at empty cell.
Do Until IsEmpty(ActiveCell)
' Check active cell for search value.
If ActiveCell.Value = Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 3
ElseIf ActiveCell.Value > Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 4
ElseIf ActiveCell.Value < Cells(ActiveCell.Row, ActiveCell.Column - 1).Value Then
ActiveCell.Interior.ColorIndex = 5
Else
ActiveCell.Interior.ColorIndex = 6
End If
' Step down 1 row from present location.
ActiveCell.Offset(1, 0).Select
Loop
End Sub


A good page as reference guide is at here - http://www.ozgrid.com/VBA/run-macros-change.htm .



---

Tuesday, March 23, 2010

Looking for live chat icon

If you are looking for live chat icon or operator pictures or even Header images for your live chat pop up windows, you can come to this URL :

http://www.providesupport.com/product/chat-icons-en.html

Here got some nice live chat icon , operator pictures and Header images, it might suite your help.



---

Wednesday, March 10, 2010

Download and install Cisco SDM

This is the link where you can download the SDM without need to register an account at CISCO. Although registering the account doesn't cost any money , but still feel annoying while try to get the SDM fast and immediately. So here is the link , which you can click and download without any question.

ftp://ftp.cisco.com/pub/web/sdm/

If you need a guide on how to install SDM , here is a good guide.

http://www.ciscobible.net/archives/754

Hope this two page will help you to setup the Cisco SDM at your desktop.

Another tips before I forget , if you connect to the device using ssh tunnel, most of the time you will access localhost , remember to use localhost instead of 127.0.0.1 , using ip address will cause the SDM failed to launch.



---

Friday, March 5, 2010

A list of mobile device emulators

If you like me plan to develop a series of application for all kind of mobile device, may be you will need some emulators to test out your application.

I found this web site from SUN, it contain a list of mobile emulator. Although it is not so up to date , but still worth to have a look.

http://developers.sun.com/mobility/midp/articles/emulators/

And also this web site , it contain newer mobile device emulator.

http://mobiforge.com/emulators/page/mobile-emulators

If you would like to see how the opera mini work , you can try your web site at these two Opera mini online demo.

http://www.opera.com/mini/demo/
http://www.opera.com/mini/demo/?ver=4



---

Wednesday, March 3, 2010

If you need a regular expression generator ...

If you are a programmer newbie like me , sometime you might need a regular expression generator to help you generate the regexp.

I tried a few site and found that this is the most suitable for me , so it might suit you as well -

http://www.txt2re.com/index-csharp.php3



---

Monday, March 1, 2010

List of Browser ID (User-Agent) Strings

One of my previous post said that you can always check your Browser ID (User-Agent) Strings by visit this web site - http://macfaq.org/hacks/useragent.html and also if you need to find out more Browser ID (User-Agent) Strings , you can visit http://www.user-agents.org/index.shtml.

Now I found another list of browser agent at http://www.zytrax.com/tech/web/browser_ids.htm . Not only a list , they also explain the meaning of the string, if you need to figure our more User agent string, feel free to have a look.



---