I'm having trouble with the following code; '
Do Until Application.Workbooks("atk softwarebuttons.xls").Sheets _
("RunData").CommandButtonMessageComplete.Click
Loop
Return (or continue on with more code after the command button click...)
Question: how can I get code to hate for a command button click tbefore continuing with VBA commands?
Note: I know a message box could be used but I do not wish to use the message box with button controls.
is there another approach; ie wait until command button click?
Do Until Application.Workbooks("atk softwarebuttons.xls").Sheets _
("RunData").CommandButtonMessageComplete.Click
Loop
Return (or continue on with more code after the command button click...)
Question: how can I get code to hate for a command button click tbefore continuing with VBA commands?
Note: I know a message box could be used but I do not wish to use the message box with button controls.
is there another approach; ie wait until command button click?