Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my worksheet, I have buttons to run macros, and I also have a
UserForm. In the worksheet code I have: Dim Money as Double Private Sub StartButton_Click() Money = 100 End Sub Then, in the UserForm code: Dim StoreMoney as Double '--I have macros that set the value of StoreMoney Private Sub BuyStuff_Click() If Money = StoreMoney Then Money = Money - StoreMoney Sheet1.Range("E9") = Money Else: OK = MsgBox("You don't have enough money!", vbOKOnly, "Not enough cash!") End If End Sub The problem is that the userform does not know that Money=100, so it just set's it at zero. How can I tell the userform code to use the variable from the worksheet code? Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems with userform, refercencing code to worksheet | Excel Programming | |||
how to prevent code running when in a worksheet code | Excel Programming | |||
Code in userform/worksheet vs. in Module | Excel Programming | |||
Code Conflicts With Worksheet Change Code | Excel Programming | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming |