Saturday, December 14, 2013

MS Excel currency converter - Number to words Latest version

MS Excel currency converter 3.0 has been updated with bug fixes.

Below are the list of bugs fixed

1.  For 1000 and 100000 it was resulting in null string. Now it has been fixed.


You can download the VBA module here. After downloading go to your Excel VBA editor. Then, go to Insert Menu, Insert Module. Paste the VBA code just downloaded. Go back to your excel spreadsheet by pressing ALT+F11. Start using the new function.

Download

Download here the Complete Excel.

Downlaod


Friday, November 22, 2013

Excel VBA macro to swap 2 values in cells

It  is very useful some times to have a shortcut to swap 2 cell values. I have created a macro in VBA to do this. Just copy paste the code below in you VBA module.

This video will help you with the procedure


Sub Swap2Values()
    Dim Value1 As Range, Value2 As Range
    Dim TempValue1 As String, TempValue2 As String
 
    If Selection.Cells.Count > 2 Or Selection.Cells.Count < 2 Then
        MsgBox "Please select only 2 cells. For other options check back soon!"
        End
    End If
   
    If Selection.Areas.Count > 1 Then
        Set Value1 = Selection.Areas(1).Cells(1, 1)
        Set Value2 = Selection.Areas(2).Cells(1, 1)
    ElseIf Selection.Rows.Count > Selection.Columns.Count Then
        Set Value1 = Selection.Range("A1")
        Set Value2 = Selection.Range("A2")
    Else
        Set Value1 = Selection.Range("A1")
        Set Value2 = Selection.Range("B1")
    End If
    TempValue1 = Value1
    TempValue2 = Value2
    Value1 = TempValue2
    Value2 = TempValue1
End Sub

Wednesday, May 29, 2013

Connecting Bluetooth headset with laptop - Bluetooth A2DP

Normal phone Bluetooth head set can be easily connected to laptop and it can be used as earphone or headphone while using skype, gtalk or any other voice chat services. All you need to do is a Bluetooth and Bluetooth driver with A2DP(Advanced Audio Distribution Profile) profile. 

You can download the necessary drivers here

Detailed step by step procedure in 

Downlaod Bluetooth A2DP driver