Adding Command buttins by macro
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 |
Adding Command buttins by macro
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 |
Adding Command buttins by macro
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 |
All times are GMT +1. The time now is 06:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com