Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
button reuser on forms
2nd post but can't see my first one from yesterday so.....
I am using a form to prompt the user with a series of questions (one at a time!) with cmd buttons for 'true' and 'false' The public sub for the 'true' button includes: -------------------------------------------------------- x = x + 1 'offest count Call next_question -------------------------------------------------------- and next_question is in module1: -------------------------------------------------------- form.Caption = "Question " & x q = ActiveCell.Offset(x, 0).Text form!question.Caption = q form!Label1.Caption = x 'variable increment test --------------------------------------------------------- Trouble is x does not increment more than once! I've tried just having the incrementing code in the form code, in a separate sub and in with the cmd true click event sub but nothing seems to work. I've got 80 questions to go on this so I don't fancy 80 forms! Any help would be appreciated J -- Jabba |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command button on forms | Excel Discussion (Misc queries) | |||
hiding forms button | Excel Discussion (Misc queries) | |||
button control on Forms toolbar | Excel Programming | |||
key Press on Forms Button | Excel Programming | |||
Option Button and forms | Excel Programming |