Sir, if i text box2 input time is less then input textbox1, then give error msg in excel... exm textbox1= 00:20, textbox2=23:30... then give error msg .
There is a calendar activex control that you can use. Although it might be on the older versions of excel. They have been trimming back their code over time. I haven't used it in a long time.
Hi! Can you please help me with this date issue i have? i have 2 cells where dates are entered ...lets say cell B4 and cell C4. B4 is manufacturing date and C4 is expiry date. I need to check through a code that C4 is not equal to today, C4 is greater than today and B4. B4 is not equal to today, and B4 is less than today. Can you please help me with the code. i am very new to VBA excel coding. I am using Excel 2016, 32 bit version.
Great Video!!!. I have many ranges in a form. i want to color the cell to show that are required. if the cell has data, no color but if the cell is blank, color the cell. Also, I want to format a number to a date (like access)? if I enter a number 121519, it will give me 12/15/19 or If I enter 12/15/19 it will give me the same things.. Thanks in advance.
I don't think it does... I would recommend you use the Format Function to convert the British Format to the US format. You could also write a function that did that for you. That is kind of a pain
Obviously you are not a teacher. Please do improve your method of teaching. Be more organized in presenting tutorials. Thanks for taking into account my opinion.
I think his videos is geared more for advance excel user who is looking for a reference. I pick it up rght away . The positive side is that the vid is short and to the point. It's hard to find that you tube nowadays.
I'm not sure what your gripe is, since you were less than clear in your post. Perhaps what you meant to say is that it was not explicated that there is no date data type for inputs, thus forcing the input to be a string. Knowing that would make clear why he doesn't immediately assign the input to a date variable.
Sir,
if i text box2 input time is less then input textbox1, then give error msg in excel... exm textbox1= 00:20, textbox2=23:30... then give error msg .
Waht about eidting tables by loking the date column or deleting data by looking the date column?
hi sir. i wanna ask if you can give us an input box to filter specific date? hope you can. thank you
There is a calendar activex control that you can use.
Although it might be on the older versions of excel. They have been trimming back their code over time. I haven't used it in a long time.
Hi! Can you please help me with this date issue i have? i have 2 cells where dates are entered ...lets say cell B4 and cell C4. B4 is manufacturing date and C4 is expiry date. I need to check through a code that C4 is not equal to today, C4 is greater than today and B4. B4 is not equal to today, and B4 is less than today.
Can you please help me with the code. i am very new to VBA excel coding. I am using Excel 2016, 32 bit version.
Could you use a formula?
It would be kind of like the example below
=if(c4today(), "if true", " if false")
I need your help again: how should I proceed to substitute the Date with a custom number on format "##.##", to be inserted like "12.45"? Thanx!
You will need to use format in the cell or range
Thank you so much for your help!
Great Video!!!. I have many ranges in a form. i want to color the cell to show that are required. if the cell has data, no color but if the cell is blank, color the cell. Also, I want to format a number to a date (like access)? if I enter a number 121519, it will give me 12/15/19 or If I enter 12/15/19 it will give me the same things.. Thanks in advance.
Do VBA supports British date format? or is it US format only
I don't think it does... I would recommend you use the Format Function to convert the British Format to the US format. You could also write a function that did that for you. That is kind of a pain
Im not sure why I came here.
Obviously you are not a teacher. Please do improve your method of teaching. Be more organized in presenting tutorials. Thanks for taking into account my opinion.
+Joseph Harouna Yaya appreciate the feedback and yes some of my videos are not the best
I think his videos is geared more for advance excel user who is looking for a reference. I pick it up rght away .
The positive side is that the vid is short and to the point. It's hard to find that you tube nowadays.
Appreciate the comment
I'm not sure what your gripe is, since you were less than clear in your post. Perhaps what you meant to say is that it was not explicated that there is no date data type for inputs, thus forcing the input to be a string. Knowing that would make clear why he doesn't immediately assign the input to a date variable.