![]() |
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 |
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 |
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