I have been trying to get edit box input from the dialog box to my control
sheet and am stuck. I have done this before but it may have been on an
earlier version of excel. Here's what I thought I could do:

Range("FirstNameBox").Text = Sheets("control").Range("FirstName").Text

Where "FirstNameBox" is the named range for the edit box on the dialog sheet.

What am I doing wrong?

Thanks