Thread: run-time error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kjeldc[_3_] Kjeldc[_3_] is offline
external usenet poster
 
Posts: 12
Default run-time error

All userforms with a DtPicker shows same problem. I can open fhe form if I
remove the DtPicker, but I do need some kind of calendar control, and none is
in the toolbox or in additionel controls
--
KCA


"RyanH" skrev:

Do you have any other code that would effect the way the Userform is loaded?
For example if you try to make a list box show a value that is not in the
list an error will show and it will highlight the line you have posted.

Is your userform name spelled correctly?

If possible post anyother code that you may have on the userform to I can
have a better clue.
--
Cheers,
Ryan


"Kjeldc" wrote:

I have in many years used a VBA-program without problems, but after opgrading
to Office 2007 i get a runtime error459 when I try to open a userform

Private Sub CmbStatus_Click()
Frmstatus.Show ' this line gives the error
End Sub

Does anyone have a solution ?
--
KCA