1. I have a userform which using 2 combobox to select the phone model(it will called for the image to display the phone image based on selection). And when the user select phone model A, it will link to the combobox in the next(phone series).
But the problem is that this file is located at the share drive that can be use by others people.
Need help to guide me on the code:
Private Sub ComboBox1_Change()
Dim photo As String
photo = ComboBox1.Value
Image1.Picture = LoadPicture("C:\Images\" & photo & ".jpg")
'Exit Sub
Me.ComboBox2 = ""
Select Case Me.ComboBox1
Case "Samsung"
Me.ComboBox2.RowSource = "Samsung"
Case "Iphone"
Me.ComboBox2.RowSource = "Iphone"
Case "Lenovo"
Me.ComboBox2.RowSource = "Lenovo"
Case "Windows"
Me.ComboBox2.RowSource = "Windows"
Case "Huawei"
Me.ComboBox2.RowSource = "Huawei"
Case Else
End Select
End Sub
2. How about if i change the first combobox to imagebox(to combine the combobox+image). When i select the imagecombo then it will call up the choices in the next combobox.
But the problem is that this file is located at the share drive that can be use by others people.
Need help to guide me on the code:
Private Sub ComboBox1_Change()
Dim photo As String
photo = ComboBox1.Value
Image1.Picture = LoadPicture("C:\Images\" & photo & ".jpg")
'Exit Sub
Me.ComboBox2 = ""
Select Case Me.ComboBox1
Case "Samsung"
Me.ComboBox2.RowSource = "Samsung"
Case "Iphone"
Me.ComboBox2.RowSource = "Iphone"
Case "Lenovo"
Me.ComboBox2.RowSource = "Lenovo"
Case "Windows"
Me.ComboBox2.RowSource = "Windows"
Case "Huawei"
Me.ComboBox2.RowSource = "Huawei"
Case Else
End Select
End Sub
2. How about if i change the first combobox to imagebox(to combine the combobox+image). When i select the imagecombo then it will call up the choices in the next combobox.