Thread: Pass variable from form to form to form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_569_] Leith Ross[_569_] is offline
external usenet poster
  
Posts: 1
Default Pass variable from form to form to form

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 With QuoteReply With Quote