Issues with VBA
#3
Are they using this from different PC's?
If so, you can trap the Application.UserName and use it.
#4
Google works very well. All of the questions that you just
asked have been asked and answered many times before.
John
"Chris" wrote in message
...
Hello all,
I have a few issues that I'm trying to get around in my small inventory
excel program. And I'm just getting my feet wet in VBA.
1) With my UserForm, I need to have it date stamp when a user updates the
inventory. The date stamp will then be placed in a column, with the rest
of
the info., called Date Changed.
2) Then when a user updates information by clicking an update button, it
replaces the data in sheet1 with the new data.
3) Also is it possible to have users log in so I can have a better way of
tracing users. Along thoses thoughts, can I have an admin in
user/password?
4) Also is there a good site I can view scripts so I can get a better
understanding? Google isn't working to well.
Thank you for any help provided.
|