signature line

[pdaws]

I have created a form in Excel 2002 that requires three different signatures.
I would like for each signature's username to appear in the specific cell
that they should sign when they review the form. Is there any way to create
such a code?

 

[Gord Dibben]

Private Sub Workbook_Open()
Dim uname As String
Sheets("Sheet1").Select
uname = Environ("UserName")
Select Case uname
Case Is = "Gord"
Range("A1").Value = uname
Case Is = "Ralph"
Range("A2").Value = uname
Case Is = "Agnes"
Range("A3").Value = uname
End Select
End Sub


Gord Dibben MS Excel MVP

 

[pdaws]

Gord, I am receiving an error message when I copied the code into a VBA module.

 

[Gord Dibben]

It has to be copied into Thisworkbook module.

Right-click the Excel Icon left of "File" on the worksheet menu bar.

Select "View Code".

Paste into that module.

But................having it in a regular module should not produce an
error, just not run.

What is the error message and number?


Gord