ExcelBanter - INKEY and VBA

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

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

- - INKEY and VBA (https://www.excelbanter.com/excel-programming/279505-inkey-vba.html)

John Hayes

INKEY and VBA

Hi,

Is there a VBA equivalent to INKEY to get input from the
keyboard?

Regards

John

Jake Marx[_3_]

INKEY and VBA

Hi John,

You're probably looking for InputBox:

Dim sAnswer As String

sAnswer = Application.InputBox("Please enter text:","TEST","Default")

MsgBox sAnswer

--
Regards,

Jake Marx
www.longhead.com

John Hayes wrote:
Hi,

Is there a VBA equivalent to INKEY to get input from the
keyboard?

Regards

John

All times are GMT +1. The time now is 02:08 PM.