ComboBox1 Change Event PLS HELP!

[willard8]

I have a comboxbox on a userform. When I open the project from my computer everything opens and works as it should. If I save the file to a shared drive and open it on another computer I get an error when trying to change the date within the combobox. The error message says "Compile Error: Can't find project or library". My code is: (apologize my html editor isn't working)

Private Sub Combobox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "mm/dd/yyyy")
End Sub

Any suggestions would be greatly appreicated!

Will

 

[RoryA]

You need to open the workbook on the computer where it doesn't work, then open the VBEditor, select Tools-References and look for any selected items that have 'MISSING:' at the start of their name.

 

[willard8]

It say's: "MISSING: McHugh Navigation Bar Control". Any ideas?

Thanks for your help!

Will

 

[willard8]

On a different computer I'm getting "MISSING: Microsoft Web Components 11.0". When I un-check the Missing component whether it be McHugh's or the Web Components, save the file, and then re-open it works perfectly. Why would something different be missing on each computer that would cause the userform to have issues?

 

[RoryA]

Not all computers have the same things installed. Since the references are saved with the workbook, you can get this sort of issue. If, as it appears, the workbook does not require the references, just remove them and save and you should be fine.

 

[willard8]

Will do, thanks very much for your help.