missing functions

[John]

when debugging I'm missing two functions that were in Power Basic.

1. Incr: Instead of "variable = variable + 1"... "Incr variable"

2.Various keyboard and hardware traps like inkey$, Input$.

inkey$ was especialy useful in stopping runaway programs.

Are there any equivilants in vb excel?

John

 

[Charlie]

You could write your own Sub and put it in a module, but most of us just do
Variable = Variable + 1

Public Sub Incr(Variable As Long)

Variable = Variable + 1

End Sub

As for Input$ there is an Input Box

Dim sVal As String
sVal = InputBox("Enter Value: ")

and as for stopping a runaway program try pressing Ctrl-Break. (At the
worst you will need to press Ctrl-Shift-Esc, find your program and kill it.
Make sure you know what you're doing here.)

HTH

 

[John]

It's the inkey$ I miss. If a key is pressed for any reason while the
program is running it is registered in inkey$. That meant you could hit
any key and stop or pause your program no matter what. "If inkey$>""
then end"
It's a lot easier than hammering away at Ctrl Break.

John