Thread: Macros and drop down boxes

Hi Everyone,

I have the following code working well in my worksheet but I would like it to be activated every time that a new selection is chosen by the user on a drop down list (located in cell C10) rather than having to create a seperate button.

Please remember that I am very much a beginner so I will need step-by-step instructions on how to perform this action.

Thank you in advance

Here is the code.

Sub Autofix()
'
' Autofix Macro
' Macro recorded 12/05/2009 by Sean Hughes
'
' Keyboard Shortcut: Ctrl+a
'
    Range("B193").Select
    Selection.Rows.Autofit
    Range("B193:J193").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlTop
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.Merge
    With Selection
        .HorizontalAlignment = xlLeft
        .VerticalAlignment = xlTop
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = True
    End With
    
End Sub

Thanks for your help Roy but my document contains huge amounts of straight text and therefore I need merged cells in order to keep the paragraph formatting consistent.
In any case my code works really well. All I need is for it to be launched when I select a new option on my drop down box.
Does anyone have an answer for me? I would be very appreciative.