- J
Export Date from text box in userform to dtpicker in sheet
Hello!i'm having trouble linking a Date box from a userform to a dtpicker in sheet (because i need the dtpicker with calendar available if the date is to be altered).I have tried this code, but obviously it didn't work...DATE1 is the box in the userform and DTPicker1 (from the development...- Thread
- date dtpicker dtpicker1.value monthview userform userform calendar textbox vba
- Replies: 0
- Forum: Excel Questions
- C
Return Year only from MonthView Calendar
How do i return the year only in a cell from a monthview calendar in a userform.Currently using the current code, where icnt refers to the last row in the sheet plus 1 and the values are yielded from a userform' With Sheets('Register') .Cells(iCNT, 1) = Calendar.Value...- Thread
- .cellsicnt calendar code monthview year
- Replies: 1
- Forum: Excel Questions
- D
How to update MonthView for current year
I made an attendance register (using Excel 2013) for my classroom about 2 years ago.It uses MonthView to select dates from a form for new student admissions.My problem NOW, is that the Monthview is still stuck in 2014 every time the form pops open. How can I change the MonthView so it reflect...- Thread
- calendar date picker monthview
- Replies: 1
- Forum: Excel Questions
- V
Can't find MonthView Control
Hii, I have use Monthview control in my form and created a addin.. but when i distributed the addin.. it gave me error project/library not loaded.. so i got missing file in Refrecens.. i installed it in the other system now it doesn't show that the reference is missing.. but i still can't find...- Thread
- addin monthview
- Replies: 2
- Forum: Excel Questions
- C
UserForm MonthView default = blank empty
Hello I want to use the Month View Calendar in my UserForm but I want to Change the Default to blank.So if someone uses my UserForm for a new entry and does not select a date, there also will be no entry in my sheet.In the Moment it automatically inserts todays date- Thread
- macro monthview userform vba
- Replies: 0
- Forum: Excel Questions
- E
Make code affect column X and Z, but not Y
I understand that I lack some basic knowledge on VBA... Hopefully I will learn these basics as I use it more....I have implemented a MonthView control on my worksheet. When I click a cell in column F, the calendar pop up. I want the same to happen for column D.I tried to change the...- Thread
- monthview
- Replies: 3
- Forum: Excel Questions
- D
Monthview show/hide
Hi all,Had a search for this but couldn't find anything.... hopefully someone can help!Basically I'm designing a user form and want the date picker to 'pop up' / appear when the user clicks in the text box and disappear when they click out of it. The input to the calendar currently populates...- Thread
- hide monthview popup show vba
- Replies: 2
- Forum: Excel Questions
- D
VBA MonthView Multiselect Start and End Date Into Cells
Hi Everyone, So I have a MonthView userform set up with the multiselect option enabled. I'm trying to get the start date and end date that the users select into two different cells on the worksheet (let's say A1 and B1 for example). From what I've looked up I understand that you can get the...- Thread
- excel-2013 monthview vba
- Replies: 0
- Forum: Excel Questions
- D
Custom Date & Time Range Userform
Hi Everyone,I'm trying to put together a userform where the user selects a date range, inputs a start time and an end time, and then hits a button to input those values combined into two cells. Here's what the userform looks like: I have it set so that the user can drag to select the range...- Thread
- dtpicker excel-vba monthview userform
- Replies: 0
- Forum: Excel Questions
- J
Monthview control Disappearing...Repeatedly
Hello all,So I've only seen this happen once before today and I thought it was something else but today I tried to use a userform where I had previously placed a monthview control, and it failed to run because the monthview control was no longer on the form..I checked my toolbox and the...- Thread
- monthview vba
- Replies: 0
- Forum: Excel Questions
- M
Custom DatePicker and Monthview no installations no add ins
ProblemDate and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues).So the additional controls are buggy (>download< - >step by step<):Microsoft Date and Time Picker Control 6.0 (SP6)Microsoft MonthView Control 6.0...- Thread
- add in datepicker end user monthview unavailable
- Replies: 3
- Forum: Excel Questions
- N
Populate Two TextBox using a Single Pop-up Calendar
Hi! Newbie here!I think this question has been posted several times and I have looked into different boards and threads but can't get my form to work properly.Basically, I have a user form with two textbox and a command button for each. The command button will call the calendar form, where...- Thread
- monthview pass by value textbox
- Replies: 1
- Forum: Excel Questions
- L
Upgraded to 2013 and now having weird issues
Hello, I was just recently upgraded from Office 2010 to 2013. I had several macros in 2010 that I used regularly that are no longer working. One of the reasons has been resolved -> it was having issues with date formats or recognizing dates even when manually typing them in. This was fixed...- Thread
- 2013 date format excel monthview upgrade
- Replies: 1
- Forum: Excel Questions
- H
Using MonthView ActiveX control, doesn't open to today's date
Hi,I'm using the ActiveX control Monthview (where a calendar pop up when you click a specific cell). But every time I open it, it display the month I create the object, not the month that the current date is. Is there some code I can add to make sure the calendar opens to the current month?- Thread
- activex monthview
- Replies: 1
- Forum: Excel Questions
- Download Microsoft Monthview Control 6 0 For Excel 2016 Download
- Download Microsoft Monthview Control 6 0 For Excel 2016 Torrent
- Download Microsoft Monthview Control 6 0 For Excel 2016 Full
Download Microsoft Monthview Control 6 0 For Excel 2016 Download
Download Microsoft Monthview Control 6 0 For Excel 2016 Torrent
Download Microsoft Monthview Control 6 0 For Excel 2016 Full
When you want to add a calendar to a userform, you can try to make use of the Microsoft Date and Time Picker Control. Unfortunately this control is not 100% reliable and a number of people have decided to make their own. In my case, I was asked by a client the other day to add a calendar. I decided to tweak a calendar I made way back in 2005. Date Picker for Excel inserts a pop-up calendar into Microsoft Excel. It works like a drop-down calendar, offering a handy date selector. As long as the date picker app is running, it activates the pop-up calendar in all the Excel files you open. It does not require you to insert an additional control into any particular Excel sheet.