Formula Problem - Help needed to autofill Userform if Data exists

Is this question in the right Posted Area?

You are accurate in the need of the Userform... The issue was that the way that the Userform was created it enters data into the EmployeeData spreadsheet and adds the data to the bottom of the sheet (Works Great). The issue is that when you use the Userform to update data on the EmployeeData spreadsheet this Userform does not do it - only addes to the bottom of the sheet next row available.

The code you suggested does not work...

Please Login or Register  to view this content.

Have you a suggestion?

John

HR Dashboard ME V5.xlsm

I have attached my Project for review

The form works well when adding a record - I would also like to use the same form to Update or edit current data in the EmployeeData worksheet.

Can the code be modified to accomplish this

Best Regards,

John

HR Dashboard ME.xlsm

I think this version will allow access into the code

The code you posted doesn't work because address is a string. The code runs because you're comparing the Target Address to another string: "$A$2:$A$98" et.al. But those are not ranges (as I suspect you had wanted them to be), just strings of characters.

Instead, you could try something like:

Please Login or Register  to view this content.

If you're still having issues, I'll take a look at your workbook.

Hi -

I have tried to understand your last post - I am sorry I am not an accomplished coder!

I have attached my Project for review

The form works well when adding a record - I would also like to use the same form to Update or edit current data in the EmployeeData worksheet.

Can the code be modified to accomplish this - if you do review - please use the last poste workbook

John

This is what I put into the EmployeeData sheet

Please Login or Register  to view this content.

It did not populate any data into the fids of the Userform from the EmployeeData sheet

I am lost for sure!

JOhn

Tried this and it did not work either:

Please Login or Register  to view this content.

John

Target.Column is a number, specifically a Long, as I had implied in my example. Target.Column will never equal "A", regardless of what you are doing. Try the columns a numbers instead of letters (where A = 1 and Z = 26), and in the meantime I will try to look at your workbook.

If this is too confusing, put a breakpoint in the first line of your code (click to the left of it in the grey bar; a red dot will appear). Run the code, then step through it (F8) line by line. Either hover over some of your variables, or set watches by highlighting and hitting Shift+F9.

This should hopefully help you gain a better understanding of what the vaiable types are and what you can be checking for in your If statements.

I made what I thought you meant - did not work

Please Login or Register  to view this content.

I am still trying!

Thanks for looking at the workbook Walruseggman

I really appreciate it

Thanks for looking at the workbook Walruseddman

I must think you are somewhat annoyed with folks like me trying to accomplish this with no experience at all...

I really appreciate it

Would like to generate a new set of eyes on this... I have applied the code as Walruseggman showed - yet the Userform will not ley me modify or edit the records that are already in the sheet - it only allows me to add: - Any Idesa?

Please Login or Register  to view this content.

Thanks

John

Would like to generate a new set of eyes on this... I have applied the code as Walruseggman showed - yet the Userform will not ley me modify or edit the records that are already in the sheet - it only allows me to add: - Any Idesa?

Please Login or Register  to view this content.

Thanks

John

These are the errors I am getting when adding the previous post code to the EmployeeData sheet in VBA:

error1.JPGerror2.JPG

Any Ideas?

John

I'm not giving up on you, I just haven't had time to look at your workbook. At this point, I don't think fresh eyes are needed, because you still have some basic syntactical errors that are preventing your code from running the way you desire.

Don't put you Row and Column numbers in quotes. They are actual numbers, not strings.

Also, double check that the name of your user form is actually UserForm. (View-->Properties)

I don't know where you got Excel.Address, but address is just a string, not an object. As such, it won't have properties like .Row and .Column.

You need to be passing in an object, which in this instance would be Range.

I'm on a tablet for now and can run any code, but I'm happy to keep helping you with issues like this in the meantime.

Sorry - Don't know how Range got changed to Address - does that impact your code?

Is this correct? - because the data from the sheet does not populate the Userform - I can add a record to the sheet - but does not allow editing of the records in the EmployeeData spreadsheet

Please Login or Register  to view this content.

Thanks,

John

I'll be on my computer in a few hours. Let me try to run the code then

Thanks,

I really appreciate your help!

So, in the last workbook you posted, the name of your user form is not "UserForm", as you had said. It's "frmCustInfo". This makes all the difference. So changing that, along with a few typos in your field names, the following code works just fine for me:

Please Login or Register  to view this content.