Adding Command buttins by macro

[Stu]

Hi there all....

Is it possible to add a command button INTO A CELL by macro - I'm OK with
writing the code, assigning it etc, but I want to add rows to a worksheet,
each of which requires a command button in the appropriate cell in column H.

Searched high and low through help, forums and newsgroups, so now I'm
writing to one.

Look forward to some kind soul's help...

Stu

 

[JLGWhiz]

Command buttons cannot be embedded into a cell on a worksheet. All controls
are added on a different object level than the worksheet. However, here is
code for adding an OLEObject command button.

Dim ws As Worksheet
With ws
Set Btn = .OLEObjects.Add(ClassType:="Forms.CommandButton.1", _
Left:=.Range("C3").Left, Top:=.Range("C3").Top, Width:=100, Height:=30)
End With