Hi.
I'll try to make this post as clean as possible.
Intro:
I am trying to create an excel-workbook that will function as a message-board.
In simplicity, the goal is that when a user opens the workbook, it will display the last messages that's been entered since the last time this user opened the workbook. As there will be many different users
It's easier to visualise this, so.. the sheet is supposed to look something like this:
......A............B.................C
1 <date> <Message> <officeusername>
2 01.10.08...test.........George Carlin(RIP)
3 02.10.08...test2........Pink Floyd
Problem:
Now my problems are as follows:
1: make excel remember WHO you are and when you last logged in
(have a macro running that records/overwrites this? in a way)
2: Based on who you are and when you logged in, skip to the first post that was entered on this date.
let's say that your last login was 03.jan.2008
Then you log in at 10.jan.2008, then it will automatically browse to 03.jan in the message-sheet, so that you can catch-up with the latest messages.
Partly-solution:
my trail of thought is as follows: I have one sheet called "messages" with
static dates in columnA, the text(messages) in columB and the signature(username) in columnC.
Then, I create another sheet (datasheet) that stores the usernames of everyone opening the workbook (and put's a static-date on it); that will function as a sortof database on when a user last 'logged in'
Then at last run a macro or similar at startup that checks who you are, when you last logged inn and finds that date in the "messages" sheet.
So far, all I've managed to do is create static-date insertion and usernames in the messages-sheet.
My codes (so far) are as follows:
code behind the message-sheet to execute a static-date in columnA on doubleclicking an empty cell:
Then as a module in the workbook, to insert the usernames:
Now what I've done to auto-insert signatures, I've written the following code in C1:
The same in C2 (with reference to A2) and so forth.
(this is a little messy, but it was all i could think of..
I also tried to insert a sub routine to do this, but it somehow failed:
)
I would really appreciate if someone has an idea on what to do next? any codes/formulas for my specific problems or if someone has a better idea on how to make a workbook like this?
*crossing fingers*
Kenneth
Bookmarks