brendalpzm
Board Regular
- Joined
- Oct 3, 2022
- Messages
- 59
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
I will explain step by step so I can explain more clear
I have this form
The data is extracted from this range
when I click in the list box value it shows the following form with the values filled
but some values are not in the listbox, some of them are in the sheet range
I'm using the following code to fill the form with the listbox values
what should I add to look for the values from the excel range as well to fill out the form?
I have this form
The data is extracted from this range
when I click in the list box value it shows the following form with the values filled
but some values are not in the listbox, some of them are in the sheet range
I'm using the following code to fill the form with the listbox values
VBA Code:
Private Sub CarList_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Load UpdateRecord
UpdateRecord.UR_Name = CarMgmt.CarList.List(CarMgmt.CarList.ListIndex, 2)
UpdateRecord.UR_Plates = CarMgmt.CarList.List(CarMgmt.CarList.ListIndex, 1)
UpdateRecord.UR_Model = CarMgmt.CarList.List(CarMgmt.CarList.ListIndex, 0)
UpdateRecord.Show
End Sub
what should I add to look for the values from the excel range as well to fill out the form?