Create User Forms of "The Course Booking Form"

**seanyeap** · 07-27-2007, 01:37 PM

Hi,
I have a little knowledge of Excel Programming and I am seeking advice and help. With reference to the http://www.exceltip.com/st/Create_Us...Excel/629.html, I managed to create the form but I somehow couldn’t get it executed. Can someone please help me? Attached herewith my file for evaluation. Thanks in advance.

**royUK** · 07-27-2007, 02:19 PM

Place this code in an Standard Module

Please Login or Register  to view this content.

Add a button grom the Forms Toolbar & then assign the macro to it.

The code below is an alternative way of coding the Form that I wrote a while ago.

Please Login or Register  to view this content.

**davesexcel** · 07-27-2007, 02:20 PM

Please Login or Register  to view this content.

The Above code wants to select a sheet called
Course Bookings
You don't have that sheet in your workbook
change it to sheet1 or what ever name of the sheet you have

**seanyeap** · 07-27-2007, 09:37 PM

Hi Dave & Roy,
I have done it and it works.All informations I input were transfered to the worksheet. How do I create a "Report" to print them? or please give me some other example so that I can review and learn. Pls take a look at my file.Thanks a million

**davesexcel** · 07-27-2007, 11:24 PM

Hi, you could add another button the the UserForm
and put a code in it something like this

Please Login or Register  to view this content.

I just got the code from the macro recorder

**seanyeap** · 07-28-2007, 04:33 AM

Hi Dave,
I have copied your codes but it didnt work.

**royUK** · 07-28-2007, 06:10 AM

Originally Posted by seanyeap

Hi Dave,
I have copied your codes but it didnt work.

That doesn't help at all! What error r you getting?

Where have you copied the code to?

**davesexcel** · 07-28-2007, 06:24 AM

Originally Posted by seanyeap

Hi Dave,
I have copied your codes but it didnt work.

Hi Sean,
You need to get your own code from the macro recorder

**royUK** · 07-28-2007, 07:00 AM

You could try

Please Login or Register  to view this content.

**seanyeap** · 07-28-2007, 11:47 AM

Hi Roy,
You have solved my problem, with the new "print command button" I could print the whole worksheet.Thanks a lot. Ok,after all data has been entered,now lets say I have 100 records and I need to search 1 particular record then print it,how do I do it,thank again.

**davesexcel** · 07-28-2007, 12:56 PM

Hi Sean,
The easiest way would be to use the autofilter
There are no formulas you just select the record you want, here is a site that explains autofilter, it would be a good idea to bookmark this site for other excel catagories

http://www.contextures.com/xlautofilter01.html

**royUK** · 07-28-2007, 01:14 PM

Take a look at the DatabaseForm example here:

http://www.excel-it.com/vba_examples.htm

**seanyeap** · 07-28-2007, 09:53 PM

Hi Roy And Dave,
Thanks for the tips and guidance.I will read it through.

**seanyeap** · 08-01-2007, 10:02 AM

Hi Roy And Dave,
I have somehow created a sample for the tutorial you gave me. However,I encountered several issues that I couldnt solve.
I have copied my existing Excel Worksheet from Row 2 to Row 15 to this new data entry form. I was unable to use the "find command button" to find and was only able to find row 16 when it was entered as new record.Pls advise.Thanks in advance.Pls refer to the attachment.