VBA Excel on Booking system

[fatty888]

Hi All experts

Greeting From Singapore

I am rusty on my VBA programming..
have return my knowledge back to my school many years

I would like to create a Transport Booking Tracking System using VBA

Anyone can help me ? Appreciated very much !

Basically the form should have the following.. i know nothing on VBA right now.. and have tried testing using the VBA but it gone wrong some where..

Basically in a excel spreadsheet

I need a userform to fill up the following

Confirmation Number ( Able to generate Confirmation Number )
Client Name
Coach Supplier ( 2 or more choices)
Transport Type ( Coach, Van , MPV )
Number of Coaches/Van/MPV ( NUmberic Only)
Departure Date (calendar style)
Departure Time (2400H)
Departure Pick up Location ( Postal Code Compulsory)
Destination ( List of destionation that i can edit and choose from listbox)
Stop Over Location ( Postal Code Compulsory)
Return Date (calendar type)
Return Time (2400H)
Stop Over Location ( Postal Code Compulsory)
Return Drop off Location ( Postal Code Compulsory)

I wish to create a masterlist and also a database for me to keep track which date is high peak and indication of the booking system

Thank you very much

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

---

Want to get your question answered quickly?

• Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
• On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
• Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
• Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
• Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

---

---

Go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
And read the FAQ on how to solicit paid help.

[fatty888]

Sorry about it Boss

[fatty888]

Anyone can help ?

[bakerman2]

The only problem is that we help you build, we don't build for you.
The least you can do is design your worksheet, design your userform and present that to us. We can then give you advice on how to improve some things and help you further with the codes you need.

[cytop]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).