Answering InpBox prompt
Is there any VBA code for answering an InputBox Prompt of another macro.
e.g. running macro "Update_at_dayend"
Sub Update_at_dayend()
Application.Run "Manual_Input"
' I need a code something like "At prompt, answer = 8.25%"
End Sub
Sub Manual_Input()
Dim ans as variant
ans = InputBox(prompt:=" Enter Tax Rate for the area."
' the rest of the program
End Sub
Thanks
|