[RESOLVED] Cancel = true error

[football0808]

Hi there,

I have a code on a userform in which when the first combo box is empty, if the user try to access the second one then he/she will receives a msg box showing up telling him/her to go back to the first one. I have used a cancel=true code to terminate the access of the second box if the first box is empty.

The problem with this is, it works on my computer and my friend's computer, but it didn't work on another friend's computer and the one I want to use the userform on. Why is this happening?

btw, I am using excel 2007 and the friend's computer that worked use excel 2010, while the one not worked are also excel 2007 i think.

Private Sub cboEquipment_DropButtonClick()
If cboIndustry.ListIndex < 0 Then
MsgBox ("Please choose an Industry/Company"), vbInformation
Cancel = True
cboIndustry.SetFocus
Exit Sub
End If
End Sub

Private Sub cboEquipment_Enter()
If cboIndustry.ListIndex < 0 Then
MsgBox ("Please choose an Industry/Company"), vbInformation
Cancel = True
cboIndustry.SetFocus
Exit Sub
End If
End Sub

Thank you!

[westconn1]

try exit sub instead

[Nightwalker83]

Why do you have exit sub within the conditional statement when there is nothing following after them? The way I see it is there is no point in using "exit sub" or "exit function" if you place on the last line of a sub or function.

[westconn1]

The way I see it is there is no point in using "exit sub" or "exit function" if you place on the last line of a sub or function.

very true, my bad answer before
to answer the original, there is no cancel parameter to the procedure so cancel is not valid, at best it would be an undeclared variable, using a reserved word for its name, in the current scope it would do nothing anyway, just omit that line

[vbfbryce]

When you say "it didn't work" on another friend's computer, what does that mean? What did or didn't it do?

[football0808]

Hi guys,

Thank you for the suggestions.
But the problem I now have is that this code gives me what I what to do (a msgbox show up to tell the user to select something from the first combo box and it will set the focus to the first combo box)
Only that on the computer I want it to work that it will occur an error and the line cancel = true is the problem.
I will try to remove the exit sub but I think the problem lies within the line cancel = true.
Is there some kind of add-in function of something.
Many Thanks!

[vbfbryce]

If you step through the code, does it give you an error on that statement, or not?

If so, what error number?

[football0808]

hi vbfbryce,

I just checked again on my frd's computer, but it is not in english so i can only say what it kind of means.
It returns something like "could not find database" or something, and in the further information button i clicked, i think it says there is a .olb file missing or something like that.
I don't know if you know what that means, because i don't see a error number or anything, thank you for helping me anyway, appreciate it.

[football0808]

hi all,

Thank you for replying, I found a solution online, I need to go to tools --> references to untick the missing bits because some computers might not have the same add-ins as mine but will be ticked as default and would be missing from other computers that doesnt have this add-ins, just untick the box with missing would do the job. Still thanks for the replies!