Excel VBA for Data Input

[DH]

Hello and HELP

I am trying to set up a macro (VBA) to simplify the data entry process
in an excel spreadsheet. I want to creat a button (with associated
macro) on sheet 1 which will take me to the data entry starting point in
sheet 2. I want the macro to step the person doing the data entry to
each cell which requires entry (i.e., the person inputs a value in one
cell and the macro then takes the individual to the cell which requires
input next. At the end of the input range, I want the macro to take the
person performing the input back to sheet 1 (the beginning point).

Any HELP would be appreciated.....

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Don Guillett]

This is not Lotus so selection is not necessary
range("a6")=inputbox("enter whatever")
range("a116")=inputbox("enter whatever")
etc

OR
You could lock the cells where entry is not permitted and protect the sheet.
Then the TAB key will take you to the next unlocked cell for an entry

 

[Dave Peterson]

Not an answer, but you may want to look at excel's builtin Data|Form.

If you try this and find it less than optimal, you could use John Walkenbach's
enhanced data form:

http://j-walk.com/ss/dataform/index.htm