Cells(lRow, 18).Value = Me.txtOtherHearKalein.Value Cells(lRow, 17).Value = strSelected '17th column! Cells(lRow, 17).Value = Me.ListBoxHowDidYouHear.Value Cells(lRow, 16).Value = Me.cboOwnCar.Value Cells(lRow, 15).Value = Me.cbodriverslicense.Value Cells(lRow, 14).Value = Me.cboContactTime.Value Cells(lRow, 13).Value = Me.cboMeansContact.Value Cells(lRow, 12).Value = Me.txtemail.Value Cells(lRow, 11).Value = Me.txtCellNo.Value Cells(lRow, 10).Value = Me.txtWorkNo.Value Cells(lRow, 9).Value = Me.txtContactNo.Value Cells(lRow, 7).Value = Me.txtPostalCode.Value Cells(lRow, 5).Value = Me.txtHomeAddress.Value Cells(lRow, 4).Value = Me.txtLastName.Value Cells(lRow, 3).Value = Me.txtFirstName.Value Cells(lRow, 2).Value = Me.cboTitle.Value
Cells(lRow, 1).Value = Me.cboCategory.Value SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1 LRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
Microsoft web expression 4 how do reset to default code#
Here's the code that I have used, courtesy of Contexture and Bernie Dietrick. Am I missing code for the listboxes that would allow for the information to clear when I unload the form? However, when checking the spreadsheet all the fields were populated accurately.Ĭan't seem to figure out why this message is coming up and why it is preventing the form from clearing for the next entry. I've built this userform and whenever I click on the command button to unload the entered information into the spreadsheet I get the "Invalid Property Value" message and the userform freezes with all the information cleared except for the listbox choices