I have one button and 10 labels stacked in a column in my worksheet.
Now when I press the button each time, it clears the caption of the last label from the bottom of the stack that has some caption displayed.
My work sheet looks as below.

Label caption 1
Label caption 2
Label caption 3
Label caption 4
Label caption 5
Label blank
Label blank
Label blank


5 <- this cell below the above label stack holds cell pointing at the last Label having Caption "Label caption 5"

[Button]<- Pressing this button each time would change a Label's caption from "Label Caption #" to "Label blank".

Can any one help me with this?

pap

This an exercise for you? Why not just have 1 label and rename the caption each time based on previous name? How are you tracking the label number it is on? How would the labels reset?
Assuming they're named Caption_Labelx where X is 1 thru 10 and it's unknown which level is currently blank then the code should be something like this:
----------------------------------------------------
  Dim iCount As Integer, oSheet As Worksheet
  Set oSheet = ActiveWorkbook.ActiveSheet
  Do While iCount < 10 And oSheet.OLEObjects("Caption_Label" & 10 - iCount).Object.Caption = "Label blank"
    iCount = iCount + 1
  Loop
  If iCount < 10 _
    Then oSheet.OLEObjects("Caption_Label" & 10 - iCount).Object.Caption = "Label blank" _
    Else MsgBox "All Label captions set to 'Label blank'", , "Notification"
----------------------------------------------------