Sleeper: Pause a Macro

[Belgarth]

This message has been cross-posted here (click here for an explanation of cross-posting)

Is it possible to pause a macro, ie after starting my macro and selecting all my worksheets i want to be able to press Ctrl+F and then pause my macro, enter data and resume, is this possible ????

Cheers

Edited by geekgirlau on 27-Mar-06, 20:39 EST; Reason: cross post

[mdmackillop]

Hi Belgarth
Welcome to VBAX
Why not add an InputBox to your code to accept your data and write it to the required locations
Regards
MD

[Belgarth]

I would if I knew how to go about it, i`m new to VBA, is it posible to show me how please ?

[mdmackillop]

I'll do that. Can you post the code that you have?

[mdmackillop]

Here's an example to write some text into cell A3 of all sheets

 
Sub Macro1()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    Sheets.Select
    Range("A3").Formula = InputBox("Enter your data")
    ws.Select
    Set ws = Nothing
End Sub

[Norie]

Cross post.