Hi,
Do You want something Like this :
Sub MakeComponentinRunTImeOnSpreadSheet()
On Error Resume Next
Dim cb As OLEObject
n = 5
For i = 1 To 10
Set cb = ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1")
With cb
.Top = n
.Object.Caption = "Do you want to Select Range"
.LinkedCell = Active.Offset(0, 5).Address
.Object.Value = False
.Visible = True
.
End With
ActiveCell.Offset(1, 0).Activate
Set cb = Nothing
n = n + 20
Next
End SubRun this Code or you can see the attached File : On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam <aaa222e...@gmail.com> wrote: > Hi all members, > > I need an Excel sheet that contains check list for about 20 items , and > that will be as a to-do note. > Can anyone help me? > > Thanks in advance > > -- > > ===================================* > * > > *Ahmed Abu Al magd** Al emam*** > General Accountant > *Al-Amana Technology Est. for Contracting* > Imam Muslim St., Dirab Road,Al Shifa.Saudi Arabia > P.O. Box 331240 Riyadh 11373 > > Tel : +966-1- 423 9742 > Fax : +966-1- 423 9734 > Mobile : +966-530722135 > > E-mail : audi...@alamana-tech.com > www.alamana-tech.com > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
CheckBox.xlsm
Description: Binary data
