bdsii
02-09-2010, 10:15 AM
I have searched high and low and it seems the code I am using should work to find data only a specified range for a value but it is not working as I thought it would. :dunno
I created a sample of what I am working on for demonstration purposes. I am attaching the sample for review.
The purpose of this is to enter completed Transaction Info into a Userform and the Userform will enter text and a date into a spreadsheet.
I want to set the Range for searching because there could be cases where the Transaction Number may conflict with data elsewhere in the spreadsheet. Once the data has been found, the code should enter "YES" into the Completed column and the completed date into the column next to it. If the Transaction Number is not found it exits the sub.
I am unable to get the Find to limit itself to only the range I specified (A1 to the total rows in the data). I am also getting an error when it checks to verify the data entered into the userform matches the Customer Number and the Account Number data on the spreadsheet. This helps prevent errors.
I am not certain where the End With statement should go which may be causing some of my problems.
Use Transaction number 77777 to edit as a test because that number is no where else on the spreadsheet. Then use Transaction Number 88888 or 99999 because those Transaction numbers are also Customer Numbers and Account Numbers. This tests to verify the search is only in Column A.
I am hoping this will also help other newbies in the future.
Thoughts and advice would be appreciated ! :yes
I created a sample of what I am working on for demonstration purposes. I am attaching the sample for review.
The purpose of this is to enter completed Transaction Info into a Userform and the Userform will enter text and a date into a spreadsheet.
I want to set the Range for searching because there could be cases where the Transaction Number may conflict with data elsewhere in the spreadsheet. Once the data has been found, the code should enter "YES" into the Completed column and the completed date into the column next to it. If the Transaction Number is not found it exits the sub.
I am unable to get the Find to limit itself to only the range I specified (A1 to the total rows in the data). I am also getting an error when it checks to verify the data entered into the userform matches the Customer Number and the Account Number data on the spreadsheet. This helps prevent errors.
I am not certain where the End With statement should go which may be causing some of my problems.
Use Transaction number 77777 to edit as a test because that number is no where else on the spreadsheet. Then use Transaction Number 88888 or 99999 because those Transaction numbers are also Customer Numbers and Account Numbers. This tests to verify the search is only in Column A.
I am hoping this will also help other newbies in the future.
Thoughts and advice would be appreciated ! :yes