I have another question, how to change the color of a cell based on empty or has data? if the cell has data, no color but if the cell is blanck, color the cell. Thanks.
Hi, this video is too good to get the date and time. But still I need some more changes in my userform. Could you help !! I want the present time to displayed on the userfrom on a Click and in this format "Thursday, Jun 16, 2016 15:42 EST "
Hi, what if I want the format but writting myself the date in the textbox, so that if I type 03312015, it automatically fills Mar/31/2015 inside the textbox
K K actually I didn't, I had to create a popup message to advice the required format, didn't dig in to it much since it wasn't a critical matter. I suggest you ask in MrExcel.com they've solved pretty much all of my questions
Great, you are teaching very deeply with all suitable examples. Thank you 😄
Well presented. Simple and effective. Thank you very much for sharing.
really this is the best solution thank you thank you for helping me i wish you the best and all your dream come true
Thank you so much. Very straightforward. That's what I exactly need.
Thank you for very useful short video
thanks for your effort video its helps me🙏👍
Excelente, no hablo ingles pero te entendí a la perfección, gracias (Thank you)
Thanks for your tutorial. It's very interesting. But what about"hours" and "minutes" ? For example in a start hour and an end hour.
THANK YOU SO MUCH MAM
Thank you.
Are you able to show us: How to Format Date on textBox and when is filled up skip to the next textBox?
Thanks for you.....
Thanks a lot, very usefull
Thank U so Much!!!!
THANK YOU VERY MUCH
I have another question, how to change the color of a cell based on empty or has data? if the cell has data, no color but if the cell is blanck, color the cell. Thanks.
Thank you. I would like to modify the date. When I insert it, I need sometime to write a day before or after but no change is alloed. Thanks
Hi, this video is too good to get the date and time. But still I need some more changes in my userform. Could you help !!
I want the present time to displayed on the userfrom on a Click and in this format "Thursday, Jun 16, 2016 15:42 EST "
Thanks!!!
v useful
thanks :-)
thank !
Eline sağlık
thank
Hi, what if I want the format but writting myself the date in the textbox, so that if
I type 03312015, it automatically fills Mar/31/2015 inside the textbox
Did you find your answer ? I am curious about it, I could make a use of this code too.
K K actually I didn't, I had to create a popup message to advice the required format, didn't dig in to it much since it wasn't a critical matter. I suggest you ask in MrExcel.com they've solved pretty much all of my questions
Hello ! How can I get dates from worksheet into Userform TextBoxes (not current date) ?
if your date is in cell B4 for example, and you want to display it on TextBox1
TextBox1.Text = Sheet1.Range("B4").Value
Hello, how about in another language?
Keeping code blurred has made it of no help.
Can u type properly please.