Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
GS expressed precisely :
Oops! I made a mistake. Revise as follows... Sub ResetButtons() Dim n As Long, v As Variant, iPos As Integer Const sButtonData As String = _ "Button 71:BI153,Button 72:BI154,Button 73:BI155" 'edit to suit v = Split(sButtonData, ",") For n = LBound(v) To UBound(v) iPos = InStr(1, v(n), ":") With Sheets("Contest Data").Buttons(Mid$(v(n), 1, iPos - 1)) .Top = Sheets("Contest Data").Range(Mid$(v(n), iPos + 1)).Top .Left = Sheets("Contest Data").Range(Mid$(v(n), iPos + 1)).Left .Width = 35: .Height = 18 End With Next 'n End Sub Sorry about that! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command button font size changes | Excel Discussion (Misc queries) | |||
command button code needed | Excel Programming | |||
Help needed moving a command button | Excel Programming | |||
Bug: Command Button Text Size Changes | Excel Programming | |||
Urgent: VBA Command Button Caption Problem | Excel Programming |