Hello,

I have created a Dialog Box which has a link to a
spreadsheet. Whatever changes I make in the spreadsheet,
it should update the dialog box, but its not doing that.

Below is the code:

Private Sub cmdOK_Click()
On Error Resume Next

Worksheets("Main").Range("I6").Value = txtMaxDmc.Value
Worksheets("Main").Range("J6").Value =
txtMaxDmcFirm.Value
Worksheets("Main").Range("K6").Value =
txtMaxDmcNonFirm.Value
Worksheets("Main").Range("I8").Value =
txtPeakPeriodCharge.Value
Worksheets("Main").Range("I9").Value =
txtOffPeakPeriodCharges.Value
Worksheets("Main").Range("I11").Value =
txtWeldingSetFee.Value


Do I have place this coding in a different function?

Please help!

Thanks,
Sheela