I want to show the AD username, current time and date on the status bar
instead of the cell so as not to disrupt the data.

how can that be done? Using VBA? Any idea?

Gary

Maybe?

Sub Staus_Bar()
Application.StatusBar = Application.UserName & " " & Now
End Sub


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:01:01 -0700, Gary Tan <Gary
wrote:

I want to show the AD username, current time and date on the status bar
instead of the cell so as not to disrupt the data.

how can that be done? Using VBA? Any idea?

Hi Gord,

Thanks for the reply. I am actually looking for the Network UserName and to
indicate the last updated date and time. Any ideas?

Thanks!

Warmest Regards,
Gary Tan




"Gord Dibben" wrote:

Gary

Maybe?

Sub Staus_Bar()
Application.StatusBar = Application.UserName & " " & Now
End Sub


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:01:01 -0700, Gary Tan <Gary
wrote:

I want to show the AD username, current time and date on the status bar
instead of the cell so as not to disrupt the data.

how can that be done? Using VBA? Any idea?

Gary,

Try code like

Sub AAA()
Application.StatusBar = "User: " & Environ("username") & " at " &
_
Format(Now, "hh:mm:ss dd-mmm-yyyy")
End Sub

The thing about this code is that it is static -- it won't update
the time. There is no way to put a ticking clock in the
statusbar. Perhaps you could use the techniques at
www.cpearson.com/excel/ontime.htm to get a ticking clock.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Gary Tan" wrote in message
...
Hi Gord,

Thanks for the reply. I am actually looking for the Network
UserName and to
indicate the last updated date and time. Any ideas?

Thanks!

Warmest Regards,
Gary Tan




"Gord Dibben" wrote:

Gary

Maybe?

Sub Staus_Bar()
Application.StatusBar = Application.UserName & " " & Now
End Sub


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:01:01 -0700, Gary Tan <Gary
wrote:

I want to show the AD username, current time and date on the
status bar
instead of the cell so as not to disrupt the data.

how can that be done? Using VBA? Any idea?

Application.StatusBar = environ("username") & ...

NickHK

"Gary Tan" wrote in message
...
Hi Gord,

Thanks for the reply. I am actually looking for the Network UserName and
to
indicate the last updated date and time. Any ideas?

Thanks!

Warmest Regards,
Gary Tan




"Gord Dibben" wrote:

Gary

Maybe?

Sub Staus_Bar()
Application.StatusBar = Application.UserName & " " & Now
End Sub


Gord Dibben MS Excel MVP

On Mon, 24 Jul 2006 20:01:01 -0700, Gary Tan <Gary
wrote:

I want to show the AD username, current time and date on the status bar
instead of the cell so as not to disrupt the data.

how can that be done? Using VBA? Any idea?