Hello,
I have created a userform to help my colleaugues properly enter enter data into a spreadsheet. The spreadsheet itself has 6 columns:
The information entered into the first 5 collumns will never change, and will be entered by myself. The last collumn entitled "latest activity" is the only one that will expand week to week, as my coleagues are to update the status of that particular project each week.
The goal is to have all the updates visible, with the last on top.:
Example:
Feb 22:Plans with engineering for approval
Jan 26: Plans being drafted
Jan 23, 2007: Budget approved
Jan 22, 2006: Budget has yet to be completed, awating input from Engineering
Initially, I had asked them to put there cursor in the front of the last comment in either the cell or on the formula bar, and hit "alt-enter" to get to the preceeding line, then enter the date and their "latest activity". But it always come back to me as a major mess.
So I am looking to control there input in that last column only by using a user form.
On the user form there are 2 textboxes, 1 for date and the other for the "latest activity:" text. Once the user completes the 2 textboxes on the userform, they click a button, and the new information should be entered in the same cell as the previous activity, but on the line immediatly on top of the previous activity.
I have the user form done, I just need to figure out how to add the data in the user form to a specific place within a specific cell.
Is it possible to do this?
I am a laymen at VBA, so please be patient.
Thanks
Bern