View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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