i don't think it is possible to add a name to a list box in any convenient manner since nobody has the answer yet from a previous post so I would like to try another way. So another way to solve my problem could be this way.
How could i designate cell B1 of a sheet to be kind of like a user prompt cell. The user would enter a name in the cell. The tricky part, this cell would then appens its value to the bottom of the list of values in Column A. You see Column A gets its values from an access export, it contains a list of names. This column is then linked to a data entry sheet and used as the values for a drop down list. I have a problem when a new name is to be entered in the data entry and thus its not ont he list already. Can a list box and a normal cell exist as one??? i figure a macro that would take the user to the file where the export occurs and lets them enter the new name in B1 and then automatically put that name at the end of the list would do the trick. This way the list that has the references would get auto-updated and everyone's happy. I've tried to insert the name name at the top of the list but it wont upidate the data entry list, so its no good. ANy idea's anyone???? please i'm im a big jam.