Search results for query: *

rmikesmith, Not sure if you will see this or if I should start a new thread but I ran into a functionality gap that I cannot figure out. Sometimes I get multiple records with the same policy number or last name. I cannot figure out where to loop the code above to capture subsequent records...

Thanks John. No Luck. Looks like they may have to live with the pain. TH

Greetings XL2000 and Win2000 I have a UserForm that is overriding/hiding the taskbar at the bottom of the screen making it not accessible when the form is up. I have "Always on Top" option set on the taskbar in Win2000. The user navigates between many apps while using the form so...

Greetings I have 10 different workbooks having data entered weekly. All the data is entered in Sheet2 in all the same columns. I need to roll these into one (Master) to provide reporting weekly. One column is "Completion Date" and if that column has a date in it, the record can...

Worked Perfect. Thanks!

I am on Win2K. I figured out a not very secure way of doing it by Putting "End" rather than "Application.Quit" on a label. Made the label blend in so it could not be seen and placed it somewhere I only know where it is. Not very sophisticated but it worked. If you could...

Geoff, Thanks for pointing out that feature of the Forum and I have done as you suggested.

I almost UserProofed myself. I launch a form when my workbook launches. I have 3 "Exit" Command Buttons on three different forms. When a User hits any "Exit" I want Application.Quit. I could not figure out how to get around the Application.Quit so I could view my code and...

We have a WINNER! I am sincerely grateful for all your help. Maybe one day when I join the Guru ranks, I can return the favor. Tony Harte

I got the syntax error to go away. There was a missing "Then" after the If Not IsEmpty. Right before that statement I put in a msgbox to show me the Result value and it is getting the right row for the policy number requested but it will still pull a record with the completion date...

Does not like: If Not IsEmpty(wks2.Cells(Result, 32)) Gives "Compile Error: Syntax Error" It was giving me the same error when I was messing around with this kind of statement the other day.

That is the first line. I would want an Else statement statement that starts again at the beginning of the Sub if Completion Date is not empty (Not allowing Users to edit and change Completed Records). I tried a couple iterations of calling the beginning of the Sub (Sub CommandButton2_Click())...

Works beautifully Mike. Thanks a ton for your help and patience. I have one column in every record that is "Completion Date" If I only want to sort on Records where this is Empty... what is the best way to accomplish this? I have tried "If Isempty Then" statements...

Thanks Mike Everything seems to be working except writing back the New record over the old. All my code is in Forms (are these Code modules?). So the code you have helped me with is in form 2, when the record is found in form 2 then form 3 is called and populated with the record. It is in...

Getting "No Match" on any policy number entered. Here is the code I have in there (Column J houses the policy numbers Starting on Row2 (row 1 is "Policy Number" title; Colum L houses the Last names Starting in Row2) I changed your A;B to J:L and Activesheet(65536, 2:3) to...

Rather than Dim SaveRowNum As Long, I meant to say....Dim MatchRange As Range in the Class Module

What is vPol? It is getting a compile error on this saying it is not defined. On the global variable I add a Class Module and put the following under General/Declarations....Dim SaveRowNum As Long Is that the correct way? Sorry for all the dumb questions but I am new to this.

Mike Also the Policy Numbers can be alpha numeric. Lastly I write the found row to a separate sheet and then reference the cells on that sheet to fill the userform referenced in the last post, maipulate the data in the userform, write over the row on the separate sheet and then replace the...

Thanks Mike. Couple things I am getting 1004 error on this Line Set MatchRange = wks2.Range(LookupRange) Says Method 'Range'of object '_worksheet'failed Will the SaveRowNum code you have save the address even after you exit the sub? I exit the sub to manipulate the data in another...

XL2000 In my code I am getting data from an input box (Policy Number) and in a later routine I search all the records for specific policy numbers to update records. If I have multiple polcy numbers in a column from top to bottom say 12345, 1234, 123 and the User enters 123 in the Input Box I...