ExcelBanter - Macro Examples for prompting info

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro Examples for prompting info (https://www.excelbanter.com/excel-programming/389055-macro-examples-prompting-info.html)

Patches

Macro Examples for prompting info

I am looking for a good source of examples to show an Excel macro that
prompts for input, then finishes executing macro using the input. Any books,
online sites, or personal inventory would help. Thanks.

Gary''s Student

Macro Examples for prompting info

Sub sonic()
n = Application.InputBox("give me a number:", 1)
MsgBox ("you gave me: " & n)
End Sub
--
Gary''s Student - gsnu200719

All times are GMT +1. The time now is 03:20 PM.