I am trying to recreate the course booking form. I cannot get the Ok
button coding to work.

It says that there is a loop without Do

Do

If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select

Loop Until IsEmpty(ActiveCell) = True

Thank

--
jack
-----------------------------------------------------------------------
jack1's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27067

You're missing an "end if" statement:
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
end if ' Add this
Loop Until IsEmpty(ActiveCell) = True

Regards,
Phil Webb


"jack1" wrote in message
...

I am trying to recreate the course booking form. I cannot get the Ok
button coding to work.

It says that there is a loop without Do

Do

If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select

Loop Until IsEmpty(ActiveCell) = True

Thanks


--
jack1
------------------------------------------------------------------------
jack1's Profile:
http://www.excelforum.com/member.php...o&userid=15486
View this thread: http://www.excelforum.com/showthread...hreadid=270677