.cellslrow

Hello, I'm trying to put together a VBA button to search all of the workbooks in a specified folder for a user inputted word in any cell (usually column A if that makes it easier). Once found I'd like it to copy the whole row to a new sheet in the Workbook the VBA is run from. Currently I have...

Hi All How can I prevent users from entering duplicate data in a userform. I have tried the data validation but this only seems to work if you type in the cell an not when the data is passed from the userform. I have the following code for the form , row 5 "seal" is the column that cannot have...

i have a userform with 3 drop down selection lists. everytime i click the arrow to list the dropdown it duplicates whats in the list over and over and over until i close the userform and re open it. is there some simple code that i can add to the userform to stop it from duplicating the lists...

Hello Everyone, I've written the following code, but I keep receiving a "Runtime error '91': Object variable or With block variable not set". I've bolded and italicized the portion of the code that is highlighted by the debugger. I'm not sure what's going on, because I believe I've ended the...

Hello All, I'm trying to do a simple module to save the results of a calculator (in excel of course) in a list. The code I am using is Sub SaveResult() Dim lRow As Long Dim ws As Worksheet Set ws = Worksheets("Calculator") lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1...