Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
-- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
I'm able to load my DT Picker just fine. Are you trying to change any of the
DT Pickers properties when the Userform is loaded? You may have something in the userform that is mislabeled? Do you have any code for when the Userform is loaded? -- Cheers, Ryan "Kjeldc" wrote: -- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
I think the problem may with the DT picker itself. Can You point me to where
I could download a new dll or ocx or whatever it is :-). The code and all userforms have worked just fine for years on other computers My programming is self-taught and my teacher was not very experienced. :-) Cheers, Kjeld -- KCA "RyanH" skrev: I'm able to load my DT Picker just fine. Are you trying to change any of the DT Pickers properties when the Userform is loaded? You may have something in the userform that is mislabeled? Do you have any code for when the Userform is loaded? -- Cheers, Ryan "Kjeldc" wrote: -- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
In VBA, right click the toolbox toolbar, then select Additional Controls,
select Microsoft Data and Time Picker, then OK. Redraw the DTPicker on your Userform and go from there. -- Cheers, Ryan "Kjeldc" wrote: I think the problem may with the DT picker itself. Can You point me to where I could download a new dll or ocx or whatever it is :-). The code and all userforms have worked just fine for years on other computers My programming is self-taught and my teacher was not very experienced. :-) Cheers, Kjeld -- KCA "RyanH" skrev: I'm able to load my DT Picker just fine. Are you trying to change any of the DT Pickers properties when the Userform is loaded? You may have something in the userform that is mislabeled? Do you have any code for when the Userform is loaded? -- Cheers, Ryan "Kjeldc" wrote: -- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
Well, as I wrote befo none is in the toolbox or in additionel controls :-(
-- My programming is self-taught and my teacher was not very experienced. :-) cheers, Kjeld "RyanH" skrev: In VBA, right click the toolbox toolbar, then select Additional Controls, select Microsoft Data and Time Picker, then OK. Redraw the DTPicker on your Userform and go from there. -- Cheers, Ryan "Kjeldc" wrote: I think the problem may with the DT picker itself. Can You point me to where I could download a new dll or ocx or whatever it is :-). The code and all userforms have worked just fine for years on other computers My programming is self-taught and my teacher was not very experienced. :-) Cheers, Kjeld -- KCA "RyanH" skrev: I'm able to load my DT Picker just fine. Are you trying to change any of the DT Pickers properties when the Userform is loaded? You may have something in the userform that is mislabeled? Do you have any code for when the Userform is loaded? -- Cheers, Ryan "Kjeldc" wrote: -- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
run-time error
I reinstalled the Officepack and now have the old boring calendar. I can live
with that but sure would prefer the dtpicker. But thanks for pointing me in the direction that it was something in the userform -- My programming is self-taught and my teacher was not very experienced. :-) cheers, Kjeld "Kjeldc" skrev: Well, as I wrote befo none is in the toolbox or in additionel controls :-( -- My programming is self-taught and my teacher was not very experienced. :-) cheers, Kjeld "RyanH" skrev: In VBA, right click the toolbox toolbar, then select Additional Controls, select Microsoft Data and Time Picker, then OK. Redraw the DTPicker on your Userform and go from there. -- Cheers, Ryan "Kjeldc" wrote: I think the problem may with the DT picker itself. Can You point me to where I could download a new dll or ocx or whatever it is :-). The code and all userforms have worked just fine for years on other computers My programming is self-taught and my teacher was not very experienced. :-) Cheers, Kjeld -- KCA "RyanH" skrev: I'm able to load my DT Picker just fine. Are you trying to change any of the DT Pickers properties when the Userform is loaded? You may have something in the userform that is mislabeled? Do you have any code for when the Userform is loaded? -- Cheers, Ryan "Kjeldc" wrote: -- KCA "Kjeldc" skrev: All userforms with a DtPicker shows same problem. I can open the 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |