Sir seems versions 2016 onwards MS has banned & removed DTP... So how to capture Date data?... I mean the user should be restricted to a particular format to enter a valid date... Eg dd-mmm-yyyy... 😪
Hello Sir I like the video but what do I do to ensure the date picker is in toolbox because it is missing. I have read many comments and the problem is common.
Sir, I want to use excel Calendar (no date time picker), but date format is becoming MM/DD/YYYY, I want format DD/MMM/YYYY, for example 21/Mar/2022 and also I want to use the same format in the Listbox1 . How can I do this by Userform in excel. Thank you.
Hi Sir I am new to VBA. I am very much thankful to you and I am writing a code for one application for my office purpose follwed by your UA-cam channel. I am transferring data from userfom to excel sheet with command button (Save). Earlier when I click, data is transferring but Yesterday on wards when I click Save, data is not transferring to Excel sheets. After closing the Userform always Excel is not working with keyboard and Run button is disabled in developer Tab Please help me to resolve this.
Dear Sir, I have a request. I use vb6 programme user form, which is open by a login form. Using user ID and Password. User Form has six command button,which are used to open Excel workbooks. What I want is that when workbook opened, the the user form must, (frmuser visible = false), and when the workbook save and closed, the user form must be, (visible= true), to choose a different workbook. What is the coding used to bring back the user form visible. Thanking you in anticipation. Ganesh
Try going to 'additional controls...' from Tools --- References in the Visual Basic Editor. Do you see more controls? If yes, then try adding 'Activex' controls.
i don't have option for Date and time picker in tool-->additional controls as well. what to do (excel 2013)
@@EvelineB error is come is not recognized as an internal or external command , operable program or batch file
Thanks for the tutorials.. but sir I could not find the DTpicker in the additional button. how to get it in the additional button.. plz kindly help..
Sir seems versions 2016 onwards MS has banned & removed DTP... So how to capture Date data?... I mean the user should be restricted to a particular format to enter a valid date... Eg dd-mmm-yyyy... 😪
Hello Sir I like the video but what do I do to ensure the date picker is in toolbox because it is missing. I have read many comments and the problem is common.
This link will help: www.exceltrainingvideos.com/calendar-control-for-all-office-versions/
Thank you!!
Welcome! Please share with your friends too.
thanks, very useful. I also need to be able to pick the time (hour). how to do it?
Thanks a lot Dinesh...
Sir, I want to use excel Calendar (no date time picker), but date format is becoming MM/DD/YYYY,
I want format DD/MMM/YYYY, for example 21/Mar/2022 and also I want to use the same format in the Listbox1 . How can I do this by Userform in excel.
Thank you.
Dear sir
i am a newer so please learn me all i can understand, Thank you
and i were here again when i can know this code
Keep watching
Thanks ... Thanks ... Thanks
Hi Sir
I am new to VBA. I am very much thankful to you and I am writing a code for one application for my office purpose follwed by your UA-cam channel. I am transferring data from userfom to excel sheet with command button (Save). Earlier when I click, data is transferring but Yesterday on wards when I click Save, data is not transferring to Excel sheets. After closing the Userform always Excel is not working with keyboard and Run button is disabled in developer Tab
Please help me to resolve this.
The link to this playlist on user-forms in Excel will guide: ua-cam.com/video/yLyPe_M1sNc/v-deo.html
Thanks. Dinesh.
gracias!!!
Thanks. Please share the tutorial with all your friends also on social media like Facebook, twitter, linkedin, etc
Dear sir!
How can I customize the monthview, so the week starts on Monday?
Thanks in advance
Regards from Sweden
/Peter
In windows 10:
1. Select Settings
2. Time & language
3. Formats --> Change Date & time Formats
4. Set 'First day of Week' to Monday
Dear Sir, I have a request. I use vb6 programme user form, which is open by a login form. Using user ID and Password. User Form has six command button,which are used to open Excel workbooks. What I want is that when workbook opened, the the user form must, (frmuser visible = false), and when the workbook save and closed, the user form must be, (visible= true), to choose a different workbook.
What is the coding used to bring back the user form visible.
Thanking you in anticipation.
Ganesh
Try this:
frmuser.visible=true
and
frmuser.visible=false
at appropriate places.
The date picker is not in my additional controls?
This tutorial in Excel will help: ua-cam.com/video/jyJFIYU1LKk/v-deo.html
How to make an empty or blank Dtpicker????
what if the date picker isn't registered?
Thanx sir
Most welcome
Additional controls not working ?
In ToolBox when I right click and select Additional Control nothing show ?
Which version of Excel are you using?
@@Exceltrainingvideos MS Excel 2010.
Try going to 'additional controls...' from Tools --- References in the Visual Basic Editor. Do you see more controls? If yes, then try adding 'Activex' controls.
hello sir the Microsoft Date and time picker is not showing in additional toolbox
www.exceltrainingvideos.com/pop-up-calendar-add-in-using-excel-vba/
only works for 32 bit versions of excel !
These VBA tutorials will help:
ua-cam.com/video/aj-WzT4Ng5c/v-deo.html
ua-cam.com/video/jyJFIYU1LKk/v-deo.html
ua-cam.com/video/zVgUtRix-IE/v-deo.html
Sir how find control panels in toolbox
Query not clear.
It's only Date Picker,, there is no time picker,, 😏
Es pura mentira,,
This will help: ua-cam.com/video/jyJFIYU1LKk/v-deo.html
oke?
Where's the burning smell coming from?