Teacher register using Visual Basic and EXCEL

[realbeginner]

Hi. I want to use VB to create a button in EXCEL which puts a 1 in a cell then moves to the row underneath. If I click the same button I want it to put a 1 in this new cell and move downwards as before. I know this is simple stuff but I'm really stuck! (I can put a button in and record a macro) [This is so I can use EXCEL on an interactive whiteboard in the classroom to do the register]

Many thanks.

 

[bjd4jc]

You should try posting in Forum707 - which is the VBA forum.

 

[dwlerwill]

Try


'Put this on your form (change tmpexcel to whatever your excel instance is called

j = 1
Do Until j = 10

j = j + 1
loop

David Lerwill
"If at first you don't succeed go to the pub"