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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
button reuser on forms
Question: How (where) are you defining x? Is it in the Sub for the button,
or is it a global variable? It is hard to tell what is happening without seeing more of your code. I suspect that either you are using a local variable that keeps getting reset when you run your code, or else somewhere else in your code you are inadvertently resetting the value of x. Can't say, though, without seeing the whole thing. "Jabba" wrote: 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 |
Reply |
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 |