Hi Tim,

You were not very specific in what you want the VBA code to do, but I think
you should look into putting the code in the Worksheet_Change Event
This is trigerred every time a user makes a Change to the Worksheet, so you
dont have to launch a Macro & then worry about having to have the focus go
back to the user. You should be able to accomplish what you want using this
event. You can even track what cell the user is in.

Also see SelectionChange Event & other Events for Worksheet

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' Set the row containing the active cell to bold.
ActiveCell.EntireRow.Font.Bold = True
End Sub


Jeff

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "C"
End Sub

"needyourhelp" wrote:

I would like to pass program control from a VBA macro to a user on a
particular sheet, let the user do whatever, then return control to VBA and
pick up where I left off with all my VBA variables/pointers intact.

I think the answer is "Design it a different way", but I thought I'd ask
since I would prefer to the let the user process the data in the already
complex spreadsheet, instead of having to dupe all the formulas in vba.


thanks,

tim