Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |||
Time sheets | Excel Worksheet Functions | |||
Formula for a time card | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |