i want to codify data entrance and bar wrong entrance on textbox??

[Selçuk1]

First of all I hope new title will be best.
the forum doesn’t see any limit.

in fact, I asked this question in macro section but there were no answer to it.Thus,I also write it here to support the archive and to find an answer.:mrgreen: :mrgreen: :mrgreen:


I want to see the entrance to some textboxes over userform as date format (like dd.mm.yyyy), to see an attention with an msgbox when an illegal entrance has made and to correct the users entrance. Or, can we make the system automatically change the entrance from the excel’s standard date format option that is still using (like dd/mm/yy) to dd.mm.yyyy format?

On the other hand, I want to add writing to textboxes without any letter. How can we make the system with attention when a wrong entrance made? For example I want user to write only "7", how can we make the system to give an attention when the user entrance "7 days"?
And I want the cursor not to pass to the next textbox when a wrong entrance made and to stay in the same textbox? How can I make this? Thanks.

Note: if I have mistakes in this translating, Im sorry for that...

With my respects.

 

[Ivan F Moala]

First of all I hope new title will be best.
the forum doesn’t see any limit.

in fact, I asked this question in macro section but there were no answer to it.Thus,I also write it here to support the archive and to find an answer.:mrgreen: :mrgreen: :mrgreen:


I want to see the entrance to some textboxes over userform as date format (like dd.mm.yyyy), to see an attention with an msgbox when an illegal entrance has made and to correct the users entrance. Or, can we make the system automatically change the entrance from the excel’s standard date format option that is still using (like dd/mm/yy) to dd.mm.yyyy format?

On the other hand, I want to add writing to textboxes without any letter. How can we make the system with attention when a wrong entrance made? For example I want user to write only "7", how can we make the system to give an attention when the user entrance "7 days"?
And I want the cursor not to pass to the next textbox when a wrong entrance made and to stay in the same textbox? How can I make this? Thanks.

Note: if I have mistakes in this translating, Im sorry for that...

With my respects.

Hi cellchug

You maybe better served by using a date control such as the Calendar control, to input your dates. This will save you a lot of coding hassles.

If you use xl2000 onwards you *should* have this control avail = MSCAL.ocx
The version is dependent on your version of Excel.

Post back if I have not explained properly or you need extra help.

 

[Selçuk1]

Hi Mr.Moala;

nice to meet you and thanks for your answer. welcome to excel.web.tr !..

Mr.Moala and the other members,

i don't know MSCAL.ocx and i use Excel2003. i found MSCAL.ocx on internet last night. i dowloaded this, i copied this file in C:\Windows\System32 (i use windows xp) . later i clicked START then RUN and i wrote "regsvr32 mscal.ocx" and i cliced OK. a msgbox opened:

"Dll Register Server in mscal.ocx suceeded"

This is real question.. :roll: :roll:
what is this?? how i can use this application and what i have to do more? i don't know your answer is whether true or not, because i don't know speciality of this applicaiton?

with my respects...

note: this question in turkish: http://www.excel.web.tr/showthread.php?t=21631

 

[Levent Menteşoğlu]

Look into the following file,

a calendar object show when double click anyone of textbox on userform1. Then select a date on calendar.

Note: You can use dtpicker object instead of textbox

 

[Selçuk1]

Look into the following file,

a calendar object show when double click anyone of textbox on userform1. Then select a date on calendar.

Note: You can use dtpicker object instead of textbox

Mr.Leventm;

thanks for your answer. very nice an application. a calendar object show when double click anyone of textbox on userform1, but date not show on textbox when i selected this.. :roll::roll: what i have to do more?? how can i copy this calendar to my another excel files? if i use dtpicker object instead of textbox, is this application run another computers? does another computers need to install mscal.ocx?