Application.InputBox
Posted by Xponet on October 24, 2001 5:19 PM
I am working on a macro - I want to place a message box in the macro for a numerical reading. I have done this in Excel 4.0 without any problems. I can't seem to get it write. I have typed every example that I could find and none of them work. I thought it was the default value, the message box appears but the cell never changes. Any help shall be appreciated.
Oh, I am stuck with Excel 97 and my problem is with VBA.
Posted by EDDIE G on October 24, 2001 5:34 PM
Are you asking for a message box that shows the result of something or an inputbox where you input a value and it shows up in a cell as shown below?
range("a1").value = inputbox("enter value")
Posted by EDDIE G on October 24, 2001 5:54 PM
MSG BOX WITH RESULT FROM CELL A1
MsgBox "The result is " & Range("a1").Value
Posted by Xponet on October 25, 2001 7:25 PM
Yes, that is the part that I was apparently leaving out. This Message Board was a lot of help. Thanks
