Steven’s Blog: May 2011

May 30, 2011

Microsoft Excel 2010

Excel Options
1. Proofing > AutoCorrect Options > AutoCorrect
Correct TWo INitial CApitals = no

2. Advanced > Editing options
Enable AutoComplete for cell vales = no

Multiple choice in drop down menu

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim rngDV As Range
   Dim oldVal As String
   Dim newVal As String
   If Target.Count > 1 Then GoTo exitHandler
   On Error Resume Next
   Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
   On Error GoTo exitHandler
   If rngDV Is Nothing Then GoTo exitHandler
   If Intersect(Target, rngDV) Is Nothing Then GoTo exitHandler
   Application.EnableEvents = False
   newVal = Target.Value
   Application.Undo
   oldVal = Target.Value
   Target.Value = newVal
   If oldVal = "" Then GoTo exitHandler
   If newVal = "" Then GoTo exitHandler
   Target.Value = oldVal & ", " & newVal
   exitHandler:
      Application.EnableEvents = True
End Sub

Conditional Formatting
New Rule > Use a formula to determine whice cells to format
Format > Font > Color > More Colors > Custom
Format > Fill > Background Color > More Colors > Custom

=$F1="complete"
RGB 0 97 0
RGB 198 239 206

=$F1="pending"
RGB 156 101 0
RGB 255 235 156

=$F1="reject"
RGB 156 0 6
RGB 255 199 206

Links

contextures.com/excelfiles.html
contextures.com/xlcondformat02.html
excelforum.com/excel-2007-help/741755-excel-2003-multiple-chooice-in-drop-down-menu-list.html

gimp.org

GIMP is an acronym for GNU Image Manipulation Program. It is a freely distributed program for such tasks as photo retouching, image composition and image authoring.

It has many capabilities. It can be used as a simple paint program, an expert quality photo retouching program, an online batch processing system, a mass production image renderer, an image format converter, etc.

May 27, 2011

Billy Idol, White Wedding

May 25, 2011

Travis, Sing

May 24, 2011

MakeMKV

makemkv.com

MakeMKV is your one-click solution to convert video that you own into free and patents-unencumbered format that can be played everywhere. MakeMKV is a format converter, otherwise called "transcoder". It converts the video clips from proprietary (and usually encrypted) disc into a set of MKV files, preserving most information but not changing it in any way.