Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Probably something really simple but.....
I am using a form to display questions and ask for responses ("true" & "false" on command buttons). the form initiallises ok and the first question is displayed (populating a label(caption)using offset and related to a worksheet "questions" where the questions are in a column) The sub for the "True" button includes a call to a public sub in a module which has the following: ------------------------------------------------------------------------------------------------ y = y + 1 x = x + 1 form.Caption = "Question " & x q = ActiveCell.Offset(x, 0).Text form!question.Caption = q form!Label1.Caption = x 'test for increase in variabl ------------------------------------------------------------------------------------------------ x is set to 1 on 'workbook open' and is used to offset for the questions and number the form The problem is that the command button only works once and the variable 'x' does not increase when "true" is hit (i.e. it stays at 1) How do i reset it please? -- Jabba -- Jabba |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Buttons using the Forms Tool bar. | Excel Worksheet Functions | |||
Forms buttons | Excel Discussion (Misc queries) | |||
Forms Buttons for use with macro - recolorable? | New Users to Excel | |||
User forms "back" buttons | Excel Discussion (Misc queries) | |||
Option Buttons on User Forms | Excel Programming |