Hello,

im working on excel sheet which use by multiple user. I want a perticular
cell in sheet to capture the username whenever they open the sheet. i've
questioned this before and i was give the formula below. I tried copy paste
the formula into vb section of excel sheet but doesnt seem to work. In the
formula there's no cell reference. So where the system will capture the
username into xecel sheet?

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Please help..

That is not a formula, that is a UDF. Add tat to a standarad VBA code
module, and in the worksheet in some cell add

=UserNameWindows()

--
__________________________________
HTH

Bob

"Dave VB logic for excel"
wrote in message ...
Hello,

im working on excel sheet which use by multiple user. I want a perticular
cell in sheet to capture the username whenever they open the sheet. i've
questioned this before and i was give the formula below. I tried copy
paste
the formula into vb section of excel sheet but doesnt seem to work. In the
formula there's no cell reference. So where the system will capture the
username into xecel sheet?

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Please help..

Dave, Bob,

I've been searching for this information - the "ENVIRON" statement that
you show below. I had an Access problem and now you helped me solve it - so
thank you. BTW the line should be UserNameWindows = Environ("USERNAME")



"Bob Phillips" wrote:

That is not a formula, that is a UDF. Add tat to a standarad VBA code
module, and in the worksheet in some cell add

=UserNameWindows()

--
__________________________________
HTH

Bob

"Dave VB logic for excel"
wrote in message ...
Hello,

im working on excel sheet which use by multiple user. I want a perticular
cell in sheet to capture the username whenever they open the sheet. i've
questioned this before and i was give the formula below. I tried copy
paste
the formula into vb section of excel sheet but doesnt seem to work. In the
formula there's no cell reference. So where the system will capture the
username into xecel sheet?

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Please help..

Sub Username()
Dim user As String
user = Application.Username
'MsgBox user
ActiveCell.Value = user
End Sub


On Monday, March 09, 2009 5:24 PM DaveVBlogicforexce wrote:

Hello,

im working on excel sheet which use by multiple user. I want a perticular
cell in sheet to capture the username whenever they open the sheet. i've
questioned this before and i was give the formula below. I tried copy paste
the formula into vb section of excel sheet but doesnt seem to work. In the
formula there's no cell reference. So where the system will capture the
username into xecel sheet?

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Please help..


On Monday, March 09, 2009 5:30 PM Bob Phillips wrote:

That is not a formula, that is a UDF. Add tat to a standarad VBA code
module, and in the worksheet in some cell add

=UserNameWindows()

--
__________________________________
HTH

Bob


On Tuesday, March 10, 2009 8:02 AM dhstei wrote:

Dave, Bob,

I've been searching for this information - the "ENVIRON" statement that
you show below. I had an Access problem and now you helped me solve it - so
thank you. BTW the line should be UserNameWindows = Environ("USERNAME")



"Bob Phillips" wrote:


Submitted via EggHeadCafe
SharePoint Get Attachment with Attachment Icon Using Javascript
http://www.eggheadcafe.com/tutorials...avascript.aspx

Sub Username()
Dim user As String
user = Application.Username
'MsgBox user
ActiveCell.Value = user
End Sub


On Monday, March 09, 2009 5:24 PM DaveVBlogicforexce wrote:

Hello,

im working on excel sheet which use by multiple user. I want a perticular
cell in sheet to capture the username whenever they open the sheet. i've
questioned this before and i was give the formula below. I tried copy paste
the formula into vb section of excel sheet but doesnt seem to work. In the
formula there's no cell reference. So where the system will capture the
username into xecel sheet?

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Please help..


On Monday, March 09, 2009 5:30 PM Bob Phillips wrote:

That is not a formula, that is a UDF. Add tat to a standarad VBA code
module, and in the worksheet in some cell add

=UserNameWindows()

--
__________________________________
HTH

Bob


On Tuesday, March 10, 2009 8:02 AM dhstei wrote:

Dave, Bob,

I've been searching for this information - the "ENVIRON" statement that
you show below. I had an Access problem and now you helped me solve it - so
thank you. BTW the line should be UserNameWindows = Environ("USERNAME")



"Bob Phillips" wrote:


On Tuesday, March 01, 2011 7:39 AM vinay tukkapuram wrote:

Sub Username()

Dim user As String

user = Application.Username

'MsgBox user

ActiveCell.Value = user

End Sub


Submitted via EggHeadCafe
Statistics, Probability, Lotteries and Dumb Programmers
http://www.eggheadcafe.com/tutorials...ogrammers.aspx