View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_74_] Jim[_74_] is offline
external usenet poster
 
Posts: 12
Default Where am I going wrong ?

I'm trying to use SetFocus but not suceeding
Please would you indicate the error in the following code

For c = StartColNo To EndColNo - 1
If Sheets("Template").Cells(RowNo, c) 0 Then
MsgBox "WARNING - This Room is not available"
UserForm1.cb_Rooms.SetFocus
Exit Sub
End If
Next c

I'm using Windows 7 and Excel 2007

Regards & TIA