Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using a userform to create an order for stock. Variables are used
during initialization, ie stklvl = whatever the max stock level is for that item. The user then enters the quantity on hand. When the user presses the enter key, the following macro executes: Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = 13 Or KeyCode = 9 Then TextBox2 = Str(stklvl) - Str(TextBox1) End If End Sub Textbox2 is the difference between max stock level (stklvl) and quantity on hand. How do I transfer the value of stklvl from the initialization macro to this macro so I can compute the difference? Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer variable to user Form | Excel Discussion (Misc queries) | |||
Transfer Variable from Form to Module | Excel Programming | |||
transfer a variable balance from one worksheet to the next | New Users to Excel | |||
how do i transfer existing excel macros to a new computer? | Excel Discussion (Misc queries) | |||
How do I transfer macros in excel between two computers? | Excel Discussion (Misc queries) |