Here is some code that creates forms toolbar checkboxes
With ActiveSheet
.CheckBoxes.Add(372.75, 46.5, 126, 63).Select
Selection.OnAction = "Macro1"
.CheckBoxes.Add(482.75, 46.5, 126, 63).Select
Selection.OnAction = "Macro1"
.CheckBoxes.Add(592.75, 46.5, 126, 63).Select
Selection.OnAction = "Macro1"
End With
--
HTH
RP
(remove nothere from the email address if mailing direct)
"akkurup" wrote in
message ...
Hi all,
I am new to this VBA area.
I have a situation where in I need to create CheckBox Dynamically.
For Example.
If the Sql statement reterieves three row i should display three
checkBox on the same line along with the results.
Can Some one helpme out with the same.
--
akkurup
------------------------------------------------------------------------
akkurup's Profile:
http://www.excelforum.com/member.php...o&userid=28316
View this thread: http://www.excelforum.com/showthread...hreadid=479030