Continue macro from current workbook

L

Len

Hi,

I'm looking for vba codes to continue running the macro from workbook1
to workbook2 after furnishing data form in workbook2 and continue
macro in workbook1

Extract codes below

Workbook1
Windows("Workbook1").Activate
Dim Frm As Object
Dim varAnswer As String
varAnswer = MsgBox("Do you want to update worksheet name ?",
vbYesNo, "OpenWorksheetNameForm")
If varAnswer = vbYes Then
Set Frm = Application.Run("'" & ActiveWorkbook.Name & "'!
OpenWorksheetNameForm")
Frm.Show
End If
If varAnswer = vbNo Then
GoTo NextSelection
End If

Workbook2
Sub OpenWorksheetNameForm()
frmWorksheetName.Show
End Sub

Any helps will be appreciated and thanks in advance

Regards
Len
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro 6
How to access a function from a different workbook 1
Making a macro only work on certain files 2
within my existing code, check for blank cells in certain rows. Ifblank, exit sub 1
Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook 2
Excel 2002 aborts randomly when closing/saving workbook 0
Giving Macro control to another workbook 3
Need help cleaning up a macro that "copies" data from another work 1

Top