Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where am I going wrong ?
Try the below
For c = StartColNo To EndColNo - 1 If Sheets("Template").Cells(1, c) 0 Then MsgBox "WARNING - This Room is not available" UserForm1.Show UserForm1.cb_Rooms.SetFocus Exit Sub End If Next c "Jim" wrote: 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where am I going wrong ?
Where is your code located?
I don't think you gave enough information to get help. Jim wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What do I do wrong [Excuses pushing the wrong key combination earlier] | Excel Programming | |||
what is the wrong? | Excel Worksheet Functions | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
Any wrong with this? | Excel Discussion (Misc queries) | |||
What is wrong?? | Excel Programming |