View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] donna.gough@hydro.com is offline
external usenet poster
 
Posts: 81
Default Syntax Problem : Grouping Buttons On A Multipage

Problem 1 still stands....can anybody please help. Syntax for the ' FOR
EACH ' line.

Problem 2 solved by changing to ' Dim NextColl As New Collection '.

- Next Problem !....I can get my collection of commandbuttons
(NextColl), but how to reference it in the .CreateEventProc ?
.........The code below does not work.

With TempForm1.CodeModule
X = .CreateEventProc("Click", NextColl)
..InsertLines X + 1, "MultiPage1.Value = MultiPage1.Value + 1"
End With