I Create a userform log in form. How do I get that loggers user name. not the application name or the environ(username).

[cmxulb]

I Create a userform log in form. How do I get that loggers user name. not the application name or the environ(username). This form below user name .

I need to add that user name here


Please Help! Thank You!

 

[Fluff]

Hi & welcome to MrExcel.
How about

.Cells(iRow,10).Value=Me.TextBox1.Value

Change the name of the textbox to suit

 

[cmxulb]

Hi & welcome to MrExcel.
How about

.Cells(iRow,10).Value=Me.TextBox1.Value

Change the name of the textbox to suit

Thanks and thanks for replying!
I get this error

 

[Fluff]

You've put the .Value in the wrong place.

 

[cmxulb]

You've put the .Value in the wrong place.

here's how the log in form look like

 

[Fluff]

That should work.

 

[cmxulb]

That should work.

does not like Me.

 

[cmxulb]

does not like Me.


View attachment 26655

also tried this, but nothing.

 

[Fluff]

Is that code in the userform module?

 

[cmxulb]

Is that code in the userform module?

frmform it the main form (database)
userform1 it the login form