Excel not responding (freezing) when typing anything in cells

Hi all,

I have an excel file (macro enabled) & it freezes when i type anything in to any cells within the table range. It freezes with not responding error & then goes normal after 10- 15 seconds. This keeps on happening repeatedly. The file has a VBA code written to execute cell data to convert as comment.

Any idea why this must be happening and how do i resolve? i tried disabling the add-ins but no success.

File attached for reference.

Thanks,
Mahesh

I had no problems with it, but I notice you have a lot of conditional formatting (some of it overlapping) in the table. That may be a problem, especially in older versions of excel.

Hi TMS,

Please see the code in the file:

Sub ConvertToComment()
Dim C As Range
For Each C In Selection
C.ClearComments
If Len(C.Value) > 0 Then
C.AddComment
C.Comment.Text C.Value & ""
End If
Next C
End Sub

I am newbie to VBA coding; a kind friend has helped with this code.

Please see if this code needs to be improved OR help with an alternative resolution, may be.

Thanks,
Mahesh