New to VBA and userforms

[hh]

Hi all,

my first post and a simple question for anyone who knows more VBA than I do...

With the help of various other postings I created a 'splash' screen (using a userform) to display a corporate logo when a worksheet is opened. How can I add the user's name to the userform? I managed to do this via a msgbox but I'm stumped as far as the userform is concerned.

TIA

hh

 

[SIXTH SENSE]

Hi!
Add a label in your user form. then on initialize event

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> UserForm_Initialize()
Label1.Caption = Environ("username")
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

i hope I got you right!

 

[hh]

Hi,

thanks for this. I had tried something similar but in the wrong place...

hh