×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Date and Number text box component...

Date and Number text box component...

Date and Number text box component...

(OP)
Is there an component for a date and number box somewhere? It would have properties like a text box except it would be for dates and numbers? If you know of it, how can I access it? Thanks a bunch!

RE: Date and Number text box component...

You can use the Calendar Control or make listboxes with the
values in the list(s)..In order to use the calendar control,
you need to select 'project', 'components' and select 'Microsoft Calendar Control' from the list. If you will using dates, I would recommend the control, because you might need to apply date logic to the lists. Generally speaking, I use listboxes/combo boxes for time pickers and a date control for a date picker.

RE: Date and Number text box component...

(OP)
Is the calendar control on Excel VBA... it doesn't seem to be there...

thanks w1sh3!

RE: Date and Number text box component...

The masked edit control is also a good way to input dates as it allows you to control what keys are accepted and in what format. For a date you have to enter ##/##/##. This will not accept letters (only numbers) and will cause an error if user enters say....45/45/45.

RE: Date and Number text box component...

I'd go with positran - the masked edit control is worth the small amount of hassle it takes to get the format right.

Mike

RE: Date and Number text box component...

Kent, you should see the calendar control in your toolbar after you go to PROJECT\COMPONENTS (in the vb ide menu) and select 'microsoft calendar control'from the list...I read that there should be a date/time picker also , but I don't use it because it's not absolutely necessary (I want to load as few ocx's as possible)...If you still can't find it, let me know what version of VB you are running..

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close