Pookiemeister
Well-known Member
- Joined
- Jan 6, 2012
- Messages
- 563
- Office Version
- 365
- 2010
- Platform
- Windows
On my spreadsheet, I have four columns. Headers are in row 1.
A1 = First Name
B1 = Last Name
C1 = Full Name (First Name + " " + Last Name)
D1 = Email Address ((First Name.Last Name@CompanyName.com)
On my form, I have a combo box (cmbMaintPersonnel) that populates with all the names in column C. When the user clicks the submit button, I need to find the name from the combo box from column C. Currently, it does not find anything. "found value = nothing" inside the watches window. Thank you. Here what I have:
A1 = First Name
B1 = Last Name
C1 = Full Name (First Name + " " + Last Name)
D1 = Email Address ((First Name.Last Name@CompanyName.com)
On my form, I have a combo box (cmbMaintPersonnel) that populates with all the names in column C. When the user clicks the submit button, I need to find the name from the combo box from column C. Currently, it does not find anything. "found value = nothing" inside the watches window. Thank you. Here what I have:
VBA Code:
Private Sub btnSubmit_Click()
Requester = Me.cmbMaintPersonnel.Value
Worksheets("Maintenance Contact").Activate
Set found = Worksheets("Maintenance Contact").Range("C2", Range("C" & Rows.Count).End(xlUp)).Find(Requester)
Unload Me
frmPurchaseOrder.Show
End Sub