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

 

[bertie]

Close Excel

See my post #5

Follow the link. It will lead you to a page where you can download the missing files.

Click the link under the header RESOLUTION. This will download a zip file which contains two files.

On my system these would be exported to c:\Windows\System32.

Open Excel, press Alt+F11.
Click Insert => UserForm
Right click anywhere on the toolbox, select Additional Controls and see if the:
MicroSoft Date and Time Picker Control is available.

================

Consider this. If you want your project to be portable so others can use it do you want them to go through this rigmarole?

Can you post what you are trying to achieve? We may be able to offer you alternatives to the DateTimePicker.

 

[reneuend]

I don't have "date picker" on my installation either. I read somewhere that you had to have Access installed. That seems odd to me. Does someone know what library this comes from?

 

[bertie]

I don't have "date picker" on my installation either. I read somewhere that you had to have Access installed. That seems odd to me. Does someone know what library this comes from?

Here is the link from post #5.
http://support.microsoft.com/default.aspx?scid=kb;en-us;297381

From here you get the Library name (and the file name)
Microsoft Windows Common Controls-2 6.0 (MSCOMCT2.OCX)

From post #11
Extract the files to (on my pc):
C:\Windows\System32

Open Excel and test if you can access the control.

 

[reneuend]

Thanks Bertie.

My concern is that I'm building an Excel Model for a very large client base and I don't think they will want to set anything up. But, I'm curious, so I'm going to download it and try it out.