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 TH-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.
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.
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
These VBA tutorials will help: th-cam.com/video/aj-WzT4Ng5c/w-d-xo.html th-cam.com/video/jyJFIYU1LKk/w-d-xo.html th-cam.com/video/zVgUtRix-IE/w-d-xo.html
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... 😪
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..
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/
thanks, very useful. I also need to be able to pick the time (hour). how to do it?
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!
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
The date picker is not in my additional controls?
This tutorial in Excel will help: th-cam.com/video/jyJFIYU1LKk/w-d-xo.html
Thanks a lot Dinesh...
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
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 TH-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: th-cam.com/video/yLyPe_M1sNc/w-d-xo.html
Thank you!!
Welcome! Please share with your friends too.
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/
Sir how find control panels in toolbox
Query not clear.
what if the date picker isn't registered?
How to make an empty or blank Dtpicker????
Thanks. Dinesh.
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.
Thanks ... Thanks ... Thanks
gracias!!!
Thanks. Please share the tutorial with all your friends also on social media like Facebook, twitter, linkedin, etc
only works for 32 bit versions of excel !
These VBA tutorials will help:
th-cam.com/video/aj-WzT4Ng5c/w-d-xo.html
th-cam.com/video/jyJFIYU1LKk/w-d-xo.html
th-cam.com/video/zVgUtRix-IE/w-d-xo.html
Thanx sir
Most welcome
It's only Date Picker,, there is no time picker,, 😏
Es pura mentira,,
This will help: th-cam.com/video/jyJFIYU1LKk/w-d-xo.html
oke?
Where's the burning smell coming from?