Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code adds 5 spinbuttons next to 5 labels into a frame.
How can I make each spinbox control ( +1 and -1) the number displayed in the label next to it? For x = 0 To 5 Set LControl = Frame1.Controls.Add("Forms.label.1") With LControl ..Caption = 100 ..Top = 10 + 30 * x ..Left = 100 ..Height = 11 ..Width = 15 End With Set SBControl = Frame1.Controls.Add("Forms.spinbutton.1") With SBControl ..Top = 6 + 30 * x ..Left = 115 ..Height = 18 ..Width = 12 End With Next Thanx, Thomas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to manipulate controls added at run-time | Excel Worksheet Functions | |||
MatchEntry for combobox added during runtime | Excel Programming | |||
add event to controls added in runtime | Excel Programming | |||
Event procedures for controls added with Controls.Add | Excel Programming | |||
creating controls at runtime | Excel Programming |