Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below, when a cell is changed in Column 2, I need to pop up a
small form to collect the Curr_User field. The calling code ... Option Explicit Public Curr_User As String Private Sub Worksheet_Change(ByVal RangeChanged as Range) If RangeChanged.Column = 2 and Curr_User = "" Then Load frmRequestor frmRequestor.Show Curr_User = cbxRequestor Unload frmRequestor End If End Sub frmRequestor only contains a combo-box to collect Curr_User and a 'Done' command button. Now see the form code ... Private Sub Done_Click() frmRequestor.Hide End Sub Private Sub UserFrom_Initialize() cbxRequestor.AddItem "Choice 1" cbxRequestor.AddItem "Choice 2" cbxRequestor.AddItem "Choice 3" cbxRequestor.AddItem "Choice 4" cbxRequestor.AddItem "Choice 5" MsgBox cbxRequestor End Sub I need the result of the combo-box choice to be globally accessable. Curr_User comes out blank because I don't understand scoping of variables that well. How do I collect this result? Thanks in advance, -Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scope of a public variable | Excel Programming | |||
Scope of Public Variable | Excel Programming | |||
How to add a variable in a range for a Combo Box | Excel Programming | |||
Scope of variable includes all Form _and_ Code modules?? | Excel Programming | |||
Refer to Combo-box using a part + variable | Excel Programming |