View Single Post
  #1   Report Post  
lashio
 
Posts: n/a
Default 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