LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default dynamic form checkbox question

i just created all of them and piled them all on top of each other using the
align menu option. i needed 40 checkboxes, too.

--


Gary


"Bob Phillips" wrote in message
...
Honestly Gary, it is the best way. Creating controls on the fly is bad news,
hard to manage, hard to maintain. If all the controls react the same way,
you can use application events to easily control them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
you know, i wondered if that's what you were going to say<g

--


Gary


"Bob Phillips" wrote in message
...
So create 40 and unhide the ones you want.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i never know how many there is going to be. there might be 4 might be

40

--


Gary


"Bob Phillips" wrote in message
...
Don't create them dynamically, create them in design, and setup the
click
events, and hide them, unhiding when required.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i create a series of checkboxes dynamically.
Set newButton5 = Me.Controls.Add("Forms.checkbox.1")
newButton5.Value = False
With newButton5
.name = checkbox & i & "C"
End With

i know how to get the value of these controls, but how do i act on

an
event?

"Private Sub Checkbox1c _click()" doesn't work.

--


Gary















 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add dynamic control (checkbox) Pluut Excel Programming 2 August 8th 06 06:19 PM
checkbox on form reset from checkbox on sheet raw[_12_] Excel Programming 1 December 3rd 05 05:08 AM
Dynamic Controls (CheckBox) using VBA in Excel akkurup Excel Programming 6 October 27th 05 01:01 PM
Add Checkbox programatically to form Matt Jensen Excel Programming 4 December 9th 04 05:22 PM
creating checkbox through form yami-s[_5_] Excel Programming 2 February 18th 04 04:18 PM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"