jammer6_9
04-10-2007, 12:52 AM
Private Sub UserForm_Initialize()
cmbCountry.AddItem "UNITED ARAB EMIRATES"
cmbCountry.AddItem "KINGDOM OF SAUDI ARABIA"
If cmbCountry.Value = "KINGDOM OF SAUDI ARABIA" Then
cmbRestaurant.AddItem "OLAYA"
cmbRestaurant.AddItem "DAREEN"
cmbRestaurant.AddItem "GERNATA"
End If
If cmbCountry.Value = "UNITED ARAB EMIRATES" Then
cmbRestaurant.AddItem "JUMEIRA"
cmbRestaurant.AddItem "CITY CENTER"
End If
End Sub
Help :banghead:... When I click "cmbcountry",,, cmbrestaurant is null...
Edited 11-Apr-07 by geekgirlau. Reason: insert vba tags
cmbCountry.AddItem "UNITED ARAB EMIRATES"
cmbCountry.AddItem "KINGDOM OF SAUDI ARABIA"
If cmbCountry.Value = "KINGDOM OF SAUDI ARABIA" Then
cmbRestaurant.AddItem "OLAYA"
cmbRestaurant.AddItem "DAREEN"
cmbRestaurant.AddItem "GERNATA"
End If
If cmbCountry.Value = "UNITED ARAB EMIRATES" Then
cmbRestaurant.AddItem "JUMEIRA"
cmbRestaurant.AddItem "CITY CENTER"
End If
End Sub
Help :banghead:... When I click "cmbcountry",,, cmbrestaurant is null...
Edited 11-Apr-07 by geekgirlau. Reason: insert vba tags