Finding a cells location and then adding a value

[Ray_n_yellow]

I have a workbook that on Sheet 2 I have 3 boxes - 1. Name 2. Amount 3. Date - I would like to select from the drop down menu the name and the date and put in the amount of cash they paid. From there I would like for the amount to be placed in that cell on page 4 that corrasponds with that date and name. Is there a way to do that?

[boylejob]

See if this does what you are wanting. On your date row I had to change those from a formula to an actual date so the search would work properly. I also made it so it would clear your fields on Sheet2 after the data has been moved.

[Ray_n_yellow]

Well now it has to run the debuger becuase there is a problem with the scripit. Not sure how to fix it - can you?

[boylejob]

When it goes into debugger what is the message that it gives you and what line of code is high lighted.

[Ray_n_yellow]

Never mind I figured that part out - now what if a new memeber comes into the group and I have to add a new person - is there a way I can click an option to add a new memeber at the bottom of box 1 on sheet 1? Will it also do all the functions on page 2 like it already is?

[boylejob]

There are some folks who do everything out on the sheet and there are others who do things behind the sheet back in VBA. I am one of those who use VBA and do very little on the sheet. In light of that here is a revision.

Lets forget about the entry sheet. I have added a button in cell A2 which will bring up the User Form you had already created. The only thing I have changed on the form is I changed the date textbox to a combobox and added a new button. The form will remain loaded until you press on Exit. After you press Record Payment it will record the payment, then it will clear the name and amount, but will leave the date. This will allow you to enter several payments for the same date.

The code used to load the name combobox will pick up any new names you add to your spreadsheet. I used a combobox for the date to be sure you could only select a date you actually have on the sheet.

Give this a try and let me know how it works for you.

[Ray_n_yellow]

When I go to put in a new name it comes up as a debug
wsSht4.Cells(lRow, lCol).Value = cAmt
am I doing something wrong?

[boylejob]

Are you entering the new name directly on the sheet or are you trying to enter it on the userform? You need to enter it on the sheet. The userform will pick up the list of names from what you have listed on the sheet.