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 headset can be easily connected to a laptop and it can be used as earphone or headphone while using skype, gtalk, whatsapp or any other voice chat services or of course to listen to your favorite music. All you need to do is a Bluetooth device and the Bluetooth driver with A2DP(Advanced Audio Distribution Profile) profile. 

Here is the detailed procedure the setup Bluetooth device with your laptop.

Some of the below steps, you may have to try multiple times. 
Make sure that your laptop has built-in Bluetooth and its switched on.



You can download the necessary drivers here


Detailed step by step procedure in 

Downlaod Bluetooth A2DP driver

VBA Macro to copy Excel data into MS Word table

The below code will help you to copy the MS Excel data into MS Word. The main thing to note here is, the Excel data is copied into Word in a...