Additional control in VBA form

[thunder_anger]

Hi all

there are two main problems here

1. Additional control dialogue box does not load and i tried every possible trick to load it and i could not.
2. i want to insert a date picker in my form. Is that possible??

thanks in advance

 

[Trevor G]

Date picker is available from version 2007 onwards.

When you open your excel workbook and use alt + F11 that takes you into the VBA screen when you select your form can you see the control box toolbar? Use right mouse button and then select more controls. Date picker can be found there.

 

[thunder_anger]

It does not load

 

[Trevor G]

There must be something missing in your installation. Perhaps try reinstalling. If you want to try another alternative, ask someone to create a workbook with a userform and add the date Picker and send a copy to you and see if you can see it and work with it on your PC.

 

[bertie]

See this link
http://support.microsoft.com/default.aspx?scid=kb;en-us;297381

I think it saves to the Windows/System32 folder.

 

[Rick Rothstein]

See the last two messages in this forum thread for a work-around to your Additional Controls problem...

http://answers.microsoft.com/en-us/...acfb6-6e6f-e011-8dfc-68b599b31bf5?page=2#last

 

[thunder_anger]

thank you guys

but still not working

it refuses to load in any user account

any body can do it for me and send me a file with the slution to my issue

 

[Trevor G]

Send me a PM with your email address in it and I will forward you a workbook with a form with the Date Picker on it

 

[bertie]

I think the DateTimePicker also needs to referencce to a library file:

Click Tools => References => Microsoft Windows Common Controls

Bertie

 

[thunder_anger]

I think the DateTimePicker also needs to referencce to a library file:

Click Tools => References => Microsoft Windows Common Controls

Bertie

can not find
Microsoft Windows Common Controls
i think i am in Mars