ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   checkbox in runtime (https://www.excelbanter.com/excel-programming/358943-checkbox-runtime.html)

[email protected]

checkbox in runtime
 
Hi, I hope that you can help me about this question.

I have a form with a tabstrip, in some of the frames that I'm using in
the tabstrip I need to create some checkboxes, until here everything
its ok but when I try to work with the click event of the checkbox it
doesn't work. Which is the correct form to do it?

With TabStrip1
Load Frame1(i)

Set chk = Controls.Add("vb.checkbox", "check1" & (i), Frame1(i))
chk.Move 3120, 3480, 255, 255
chk.Visible = True
If check1(i).Value = Checked Then 'error Object variable or With
variable not set
For h = 0 To 8
Set t = Controls.Add("VB.TextBox", "TextBox" & (i) & (h),
Frame1(i))
t.Move xcor(h), ycor(h) + 4000, twidth(h), theight(h)
t.Visible = True
Next
End If
End With

xcor, ycor, twidth y theight are Arrays

thanks in advance

Javier Martinez


Bob Phillips[_6_]

checkbox in runtime
 
Suggested alternative. Add the checkboxes and the event code at design time,
and hide them until you need them .

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
Hi, I hope that you can help me about this question.

I have a form with a tabstrip, in some of the frames that I'm using in
the tabstrip I need to create some checkboxes, until here everything
its ok but when I try to work with the click event of the checkbox it
doesn't work. Which is the correct form to do it?

With TabStrip1
Load Frame1(i)

Set chk = Controls.Add("vb.checkbox", "check1" & (i), Frame1(i))
chk.Move 3120, 3480, 255, 255
chk.Visible = True
If check1(i).Value = Checked Then 'error Object variable or With
variable not set
For h = 0 To 8
Set t = Controls.Add("VB.TextBox", "TextBox" & (i) & (h),
Frame1(i))
t.Move xcor(h), ycor(h) + 4000, twidth(h), theight(h)
t.Visible = True
Next
End If
End With

xcor, ycor, twidth y theight are Arrays

thanks in advance

Javier Martinez





All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com