Ejemplos del uso del control DtPicker de Visual Basic. You could try the Microsoft Date and Time Picker Control. To use it, in the Toolbox, you rightclick and choose Additional Controls. Then you check Microsoft. DateTimePicker is a ActiveX controls. The DateTime Picker control allow the user to specify a date and time. DateTime Picker control can display a MonthView as a. Ol excelente TOPICO ele me ajudou e MUITO apenas quando fui utilizar o note nao encontrei Microsoft MonthView Control 6. Visual Basic 6. 0 ActiveX ActiveX. This topic describes the styles and templates for the Calendar control. You can modify the default ControlTemplate to give the control a unique appearance. Al parecer la versin 2010 tiene problemas con el control calendar, intenta con el control Monthview o DTPicker para que te aparezca un calendario y puedas tomar una. KMLXmH85gJU/UXmgye6qYaI/AAAAAAAAAfE/ajlvzB5mg3I/s1600/Republik-VB6-3.jpg' alt='Microsoft Monthview Control 6.0' title='Microsoft Monthview Control 6.0' />How to Add Date Picker in Excel VBA Forms. If you are using MS Excel for the longest time or if you are just new to this prowerful spreadsheet program, you might want to add some date picker functionality on your sheets. This fancy feature is mostly encountered on web forms but they can be applied or utilized in MS Excel too using Visual Basic for Applications VBA forms. Microsoft Monthview Control 6.0' title='Microsoft Monthview Control 6.0' />New MicroCharts item and standalone control added with 8 chart types. Can be hosted on menu, ribbon, toolbar or standalone. Designed to be super fast renders. Espero no estar molestndote mucho, pero desde que descubr las macros he aprendido muchas cosas y muchsimo mas contigo que me has ayudado en muchsimas. Visual Basic Banco de Dados Tudo sobre Visual Basic, VB. NET, C, ASP, ASP. NET, ADO. NET. Diversos Projetos Exemplos codigo fonte documentados artigos. The use case for this varies depending on who would actually use the spreadsheet. If you are the Excel VBA programmer, you might want to utilize a macro that can manipulate user entries with dates using the date picker. If you are the user, you can use templates or macro enabled spreadsheets to have this pop up calendar type Date Picker in your workbooks. How to Use the Date Picker in VBA Forms. If you are wondering to to use a Date Picker in one of your Excel workbooks, the procedures are described below. I am using MS Excel 2. Excel 2. 00. 7, and 2. I have not yet tested Excel 2. Step 1 Open your MS Excel and then click on the Developer tab. If you do not see the Developer tab at the top of your menus, please follow this link for the detailed procedures. Step 2 When the Developer tab is open, on the leftmost group of icons called Code, click on Visual Basic. A new window shall open named Visual Basic for Applications. This window can also be shown by simply pressing the AltF1. Excel window. No need to go to the Developer tab. Step 3 In the Visual Basic for Applications window, click on the Insert menu, then click on User Form. Then a new formcomponent appears on the file list on the left, and a new form object appears. Step 4 When the User. Form object is shown, by default the small Toolbox appears as well. If you are not seeing it on your screen, click on the View menu, then click on Toolbox to enable or show it. Step 5 By default, the calendar pop up Date Picker control is not yet enabled and not listed on the default set of controls on the Toolbox. To enable it, right click on any buttons or controls on the Toolbax, then click Additional Controls. Step 6 In the list of Additional Controls, scroll down to the middle or bottom part, locate of the item listed as Microsoft Month. View Control 6. 0 SP6, click on it to mark it for selection, then click OK. Step 7 The Additional Controls dialog box disappears, and then look at the Toolbox and confirm that the calendar icon Date Picker is now shown on the Toolbox. Reg Fix Ind. Step 8 Now you are ready to select the Month. View button and create the pop up calendar Date Picker on the User. Form. One of the problems that other people encounter when doing the procedures above is that, the Microsoftr Month. View Control 6. 0 is NOT listed in the Additional Controls dialog box. This is because MSCOMCT2. OCX file is missing in their system. The procedures below describe how the MSCOMCT2. OCX can be downloaded and registered to your Windows OS running the compatible version of MS Office in order to enable and activate the Microsoftr Month. View Control 6. 0. How to Install and Enable the Microsoftr Month. View Control 6. 0. NOTE Close your MS Excel and other MS Office programs before following the steps below. Step 1 Download the cabinet file containing the OCX file needed for the date picker to work. This file is no longer accessible at the MSDN network so I made it available on the cloud. Here is the link  http filesxpress. Step 2 Extract the contents of the cabinet file into a folder. You can name it MSCOMCT2. The contents of the cabinet file are 2 files shown below Step 3 The file with no extension is actually a batch file. It will automatically execute the registration of the OCX file to the System. So you right click on the file with no extension, then click on Run as Administrator. When you got the UAC prompt, click OK or YES to confirm. Step 4 The action initiated by this batch file is actually copying the OCX file to the System. Step 5 If you are using a 6. Windows, there are extra steps needed. Copy the OCX file to the Sys. WOW6. 4 folder. The actual path is C WindowsSys. WOW6. 4Step 6 When prompted with the UAC, click OK or YES to confirm the action. Step 7 After copying, open an elevated command prompt. To do this, right click on the Windows logo Start menu then click Command Prompt Admin. Step 8 In the elevated command prompt, type or copy and paste this command below into the command prompt and then press Enter to execute. C WindowsSys. WOW6. MSCOMCT2. OCXThen close all programs and then the open MS Excel. The Microsoftr Month. View Control 6. 0 shall be listed now and can be enabled to allow you to add the pop up calendar Date Picker using the procedures above. Cmo puedo activar o instalar el calendario Active. X Control de Excel. Microsoft Excel. Entra a la siguiente liga para descargar los archivos mscomct. Los archivos debers descargarlos en C windowssystem. Despus entra a excel, y realiza los pasos que se muestran en la siguiente liga http support. Despus de lo anterior, intenta nuevamente con el archivo que te envi.