choubix
07-16-2008, 07:56 PM
hello,
I have a combobox that where the user can select Equity/Bonds/Alt Invt
Is it possible, isntead of returning these values to return 1 for Equity, 2 for Bonds and 3 for Alt Invt when the user makes a choice?
I post my code here:
For i = 1 To 6
'Security Type
bfSectype = "Sectype" & CStr(i)
With Me.Controls(bfSectype)
.AddItem "Alt Inv"
.AddItem "Equity"
.AddItem "Bond"
End With
'Zone
bfZone = "Zone" & CStr(i)
With Me.Controls(bfZone)
.AddItem "Asia"
.AddItem "Emerging Mkts"
.AddItem "Europe"
.AddItem "Japan"
.AddItem "US & World"
End With
Next i
on a separate issue: is there a way to prevent the user from NOT using the values that are part of the list? (right now, the user can override the dropdown list and write wathever he wants)
thanks!
I have a combobox that where the user can select Equity/Bonds/Alt Invt
Is it possible, isntead of returning these values to return 1 for Equity, 2 for Bonds and 3 for Alt Invt when the user makes a choice?
I post my code here:
For i = 1 To 6
'Security Type
bfSectype = "Sectype" & CStr(i)
With Me.Controls(bfSectype)
.AddItem "Alt Inv"
.AddItem "Equity"
.AddItem "Bond"
End With
'Zone
bfZone = "Zone" & CStr(i)
With Me.Controls(bfZone)
.AddItem "Asia"
.AddItem "Emerging Mkts"
.AddItem "Europe"
.AddItem "Japan"
.AddItem "US & World"
End With
Next i
on a separate issue: is there a way to prevent the user from NOT using the values that are part of the list? (right now, the user can override the dropdown list and write wathever he wants)
thanks!