Userform that pulls and Edits cells

Hi

What data is supposed to be going into the listbox when the form loads?

rylo

as of right now it's supposed to be pulling column A (last name), but i want it to pull column 4 (claim number)

also, the user form that i'm having trouble with seems to work on my home computer when i'm working on it from here, but will not work when i'm at work, which is what's it's being created for.

Hi

The formula for the defined name FirstField has an error in the example file.

How about you correct that, rebase it on column D as required, and update the example file.

I did a quick hack around, and it updated the Firstname when that formula was altered.

rylo

You gotta forgive me, I'm REALLY new at this and do not have anyone at work to learn from. i don't know where the error is occurring from, or how to rebase the Firstfield on Column D instead of A. It seems when i created another test file using the same coding it works, but when i open the test file that I posted up previously, it gives me run-time error ‘380’ – Could not set the RowSource property. Invalid property value”, which is probably the error that you received, but the coding was not changed. I have changed the coding, as shown below, but it doesn't seem to change where the rowsource data is being pulled from on the listbox. To me, it looks like the code is reading like this:

in userform, the data source for listbox1 is coming from A2-G, pulling from Row D specifically
frmEditData Listbox1 shows this data labeled as FirstField.

Is that right?

Please Login or Register  to view this content.

Again, thanks for your help, and forgive my incompetence in all of this, I'm really trying to learn.

Hi

I've updated your example file and the edit seems to be working now.

rylo

Thanks!! It works perfect now!!