ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   missing functions (https://www.excelbanter.com/excel-programming/392585-missing-functions.html)

John[_132_]

missing functions
 
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

missing functions
 
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" wrote:

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


John[_132_]

missing functions
 
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

Charlie wrote:
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" wrote:


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



All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com