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

Why a command button, you could end up with hundreds!, what would the
button be for?, because you could have one button that only runs the
macro for the active row if thats what you want!

Stu;188991 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52105

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

"Stu" wrote:

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