Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an excel quiz for my classes. From a worksheet, students click a
button to launch a form; After answering a question, they click a next button to view the next form; Each form has a uniquely named option button that represents the correct answer. At the end of the last form is the show score button, which calls a new form to display the percentage correct; How do I go about passing the score variable? TIA for any suggestions. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello Headly, Declare the score variable as Public in a standard VBA Module. The code in the "Next" form button should update "Score". Module Code: Public Score As Single "Next" button code: UserForm1.Hide Score = Score + NumberRight UserForm2.Show Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=546942 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pass string value to another form | Excel Programming | |||
How to pass a variable from Form back to calling procedure | Excel Programming | |||
Pass value from form to form | Excel Programming | |||
Pass variable from user form to macro | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |