PDA

View Full Version : Solved: event to capture changing the height or width of a cell



philfer
12-03-2009, 06:49 AM
Hello,

Is there an event that can capture when a user changes the height or the width of a cell (regardless of the way they do it i.e. increase a column by dragging a handle or from the menu)

Worksheet_Change doesnt seem to fire for this

Thanks
Phil

GTO
12-04-2009, 04:37 AM
Greetings Phil,

There's no supplied worksheet/workbook event, and as far as I know, one is limited to what the app supplies in this area.

Mark

mdmackillop
12-04-2009, 05:24 AM
A possible workaround that could be developed to include columns and indication the cell that was changed.

Option Explicit

Dim RwCheck

Private Sub Worksheet_Activate()
RwCheck = Cells(1000, 1).Top
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1000, 1).Top <> RwCheck Then
MsgBox "Something has changed"
RwCheck = Cells(1000, 1).Top
End If
End Sub