Return to Sheet after displaying User Form 1

[artsandcraftshome]

I would like to return to my sheet after displaying a user form, but it just returns me to the VBA page (after flashing the sheet but not retaining it). Any ideas why this is happening?
Thanks for any help you might offer..I'm stumped. John
Here's my code:

Sub eMD()
Sheets("eMD&quot.Select
AVGDIM = InputBox("Enter the average Field Size on skin (cm)&quot
Range("C7&quot.Select
Selection.FormulaR1C1 = AVGDIM

PRESCD = InputBox("Enter the Prescription Depth(cm)&quot
Range("C8&quot.Select
Selection.FormulaR1C1 = PRESCD

'Set the variable PDEPTH to the prescription field depth
PDEPTH = Range("I7&quot.Value
SKINFS = Range("I8&quot.Value
'Display the PDD table sheet
Sheets("PDD TABLES&quot.Select
'Select the row for the prescription depth and the column where this FS PDD starts
Cells(SKINFS, PDEPTH).Select
'Display a form that will retrieve the value of PDD from the PDD table
frmeMD.Show
'Set the sheet back to the eMD sheet
Sheets("eMD&quot.Select
Range("C10&quot.Select

End Sub

AND HERE'S THE CODE FOR THE USER FORM:
Private Sub CommandButton1_Click()

Dim SelRangeMD As Range
Dim AddrMD As String
'Get the address from the RefEdit control
AddrMD = RefEdit1.Value

'Set the SelRange object to the range specified in the RefEdit control
Set SelRangeMD = Range(AddrMD)

MDCHOICE = SelRangeMD.Value

ThisWorkbook.Worksheets("eMD&quot.Range("C10&quot.Value = CInt(MDCHOICE)

'unload the UserForm
Unload Me

End Sub


Private Sub UserForm_Click()

End Sub

 

[Zathras]

That's because you are running it from the VBA editor. Run it from the worksheet and you will return to the worksheet. Either use Alt-F8 or assign a macro shortcut (or drop a button on the sheet and assign a macro to the button.)