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.

Chris,

I'll try to tackle a couple of your questions to get you started.....

the date stamp:
Would you want to check to see if anything was actually changed before you
changed the date stamp?
When you bring up the UserForm, I'm assuming that you're populating it with
values from
a row on a sheet?
You might want to match the values on the form to what "was" on that row
before changing the date stamp.

Replacing the data with an update button:
Where did you get the data? If it was from a row, you need to trap and save
the row number
so that you can write back to the same row.
Example:
Lets say that rows 5 through 20 have data.......
User clicks on row 6.

Dim aRow as Long
aRow = ActiveCell.Row

In the UserForm.Activate Event

TextBox1.Value = Range("A" & aRow).Value

The above will get whatever is in A6 and place it in TextBox1

Going the other way with the Update button......

Range("A" & aRow) = TextBox1.value

Hopefully the above will get you started in the right direction,
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.

http://www.cpearson.com/excel.htm

http://www.j-walk.com/ss/excel

go to the developer tips from the left side.

http://support.microsoft.com
go to advanced search, and select one of the excel versions, and some key
words.

For information on userforms:
ttp://www.visualbasicforum.com/showthread.php?p=594409#post594409


http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp

--
Regards,
Tom Ogilvy


"Chris" wrote:

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.

#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.