The Course Booking Form

  • Thread starter Thread starter jack1
  • Start date Start date
J

jack1

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering data from a userform into multiple sheets 2
Excel UserForm issues: Textboxes cannot be blank 1
Copy Active Range from one workbook to another 1
Issues with UserForm Box 5
Programming problem. 1
Trying to Avoid Selecting Sheets 2
Type mismatch error only on the first run 2
if then else 8

Back
Top