Date Picker doesn't work when workbook is reopened

[TPDave]

Hi All,

I've made a sheet with a date picker that works fine, but when the book is reopened the picker doesn't work until I click "Source" in the developer tab at which point it comes to life and works perfectly.

Example attached, any help with this would be greatly appreciated! Thanks

[:) Sixthsense :)]

Click Design Mode Under Developer Tab.

Select the Date Picker Object>>Do right Click>>Selct Properties>>Locate Linked Cell>>Paste the below Reference in the Linked Cell input area

Sheet1!B2

Close the properties window>>De-select Design mode and select the desired date in the date picker and check

[TPDave]

Hi SixthSense,

I'm still getting the issue, it's not that the date picker isn't outputting the date, it's that when I open it the formatting is screwed up and it doesn't function until I click the Source button. Before and after pictures of the problem on the sheet attached.Before.jpgAfter.jpg

[:) Sixthsense :)]

Try to re-install that controls, you can download it from here...

http://activex.microsoft.com/controls/vb6/mscomct2.cab

Close Excel application and Open the downloaded file which will copy the required controls to the concerned root directory.

Open your file and check...

[TPDave]

Hi SixthSense,

I'm still getting the same error unfortunately

[:) Sixthsense :)]

Try to recreate it and check

[TPDave]

I don't understand what you mean by recreate? There is a workbook with the problem attached in the first post and screenshots of the issue I'm encountering when using that workbook attached in my second post. What other information are you after?

Thanks

[:) Sixthsense :)]

Create a new DatePicker Date Control in that workbook and check whether that is also reacting in the same way...

Because I attended the same type of question previously in which I suggested the user to create a new date picker control and it worked successfully.

So your current control may be badly getting affected.

So please create a new one and check and confirm

[TPDave]

Aah - gotcha.

Still not working unfortunately. I've uploaded the amended file and attached a screenshot of what I see when I open it.

ThanksVBA_Example.xlsmSecond.jpg

[:) Sixthsense :)]

For me also it is showing like that only... lol

After opening the file you just use the scroll button in mouse and scroll it upward and downward it will be ok

[TPDave]

That's embarrassingly simple, I'm so sorry for wasting your time!!

[PrasadvChaudhari]

Hi,
I am also facing same issue.
Is there any way we can fixed it. I don't want tell tell my user to follow scroll down and up to resolve this issue. it looks like immature resolution. kindly help.

[FDibbins]

Hi,
I am also facing same issue.
Is there any way we can fixed it. I don't want tell tell my user to follow scroll down and up to resolve this issue. it looks like immature resolution. kindly help.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread