On updated event does not fire

Ben2k

Board Regular
Joined
Oct 16, 2002
Messages
77
I have a calendar 10.0 control on my form, for the On Updated event I have the following code.

Private Sub Calendar9_Updated(Code As Integer)
' when new date is selected update delivery date textbox
Dim newdeldate As Date
newdeldate = Calendar9.Value
MsgBox (newdeldate)
DateOfDelivery.SetFocus
DateOfDelivery.Text = newdeldate
End Sub

When I select a date on the calendar nothing happens, the event is not firing for some reason. How can I fix it?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Try using the Click event of the Calendar control.

BTW

Where did you get the control from?

I downloaded your database and it wasn't the standard calendar control.
 
Upvote 0
It doesn't have an on click, all it has are

On updated
On enter
On exit
On got focus
On lost focus

I'm not sure where it came from, it was just in the list when you click more controls called CalendarVB. It wouldn't work on any other PC's just mine, that's why i'm using the Microsoft Calender 10.0 one now.
 
Upvote 0
No On_Click, just the ones I mentioned

On updated
On enter
On exit
On got focus
On lost focus

Quite strange really?
 
Upvote 0
Try going to the code editor and check to see if it has one.

i.e. in the top left dropdown select the control and in the right dropdown all it's events will be listed
 
Upvote 0
Ah I see, yes it does and its working now.

Wonder what the On_Updated event is for then?

Thanks for your help.

I've managed to make a lot of progress now with my database now. I was able to get the information I wanted onto the form by using DLookup
 
Upvote 0
Ben2k

If you want I can take a look at your database.

I did previously download it but that took ages.

Could you send me a zipped copy?

Email
 
Upvote 0
Thanks for offer but like I said I think i'll be okay now, if I get stuck i'll zip it and mail it to you.

Ben
 
Upvote 0

Forum statistics

Threads
1,221,773
Messages
6,161,855
Members
451,724
Latest member
sledparty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top