Hi!

I've got a userformthat prompts the user for two dates, and a signature;

Private Sub cmdok_Click()
Dim signature As String
Dim fromdate As String
Dim todate As String

fromdate = txtdatefrom.Value
todate = txtdateto.Value
signature = txtsign.Value

macro1

userinput.Hide
End Sub

However, when "macro1" is executed, no values appear where "fromdate", "todate" and "signature is used. Why?

As you might guess this is my first time using a userform

Help appreciated!

-M-