excel form creation

I have a spreadsheet that we use at work and I would like to be able to create a form to make it faster and much more user friendly.

We all use 2007.
There are 21 columns and each row will be a new item when the form is completed.
There are multiple formats for each column.
I need the form in one sheet and the table of data in another.

Is there a gui where I can create this. If I hit ALT+F11 I get the programming screen. But where to from there?

Any assistance would be greatly appreciated.

Originally Posted by Mordred

Hi rawtech, in the VBE, click on insert and then select unserform

I am in there now fumbling my way through the labels and text feilds and all that, looking at some date picker stuff now.

Just wondering though, how does this know where to put everything once the form is filled in.

By the way the nifty people I work for blocked good ol youtube

btw, thank you for the welcome :-)

Sorry Pike, I meant to disrespect to the way this or any other forum works.
I am running through one of the links suggested above. Hopefully I will get it going, and I will post questions as they pop up.

Just looking at this example, is there a way to have the form, once created display on a sheet rather than have a button to pop it up ?

http://www.exceltip.com/show_tip/Use...Excel/629.html

What I meant was that on that example, there is a button on 1 sheet when you click on it the user form opens up. Is there a way to just have the for displaying already and not have to click on the button to open it?

Great, that worked fine, but a small issue if I am being picky...

I saved that code under sheet2. I then went to sheet2 and it popped up as expected, I then closed it and saved the file while sheet2 was displayed. I then closed and re-opened the file and I had to click away and then back to sheet2 for it to display.

Is there a way to have it display permanently in sheet2?

I have the below code to display the date and time and it does it well.

Please Login or Register  to view this content.

I also have a txtDuration box on the userform.
Is there anyway to have an If statement to disable the the txtDuration box until start date/time and end date/time has been filled in and then it will be anabled and display the duration in hours and minutes and also add it to the sheet in ActiveCell.Offset(0, 11)

Here is the sheet I have been working on.

I have everything working except the FIND button which I haven't even started to research yet. I have been learning a bit thanks to you pushing me to learn

I have been just now researching on how to display the the duration in days, hours & mins.
I have found something I am not sure if it will work though, haven't had time to try it just yet. http://www.ozgrid.com/forum/showthre...t=51729&page=1

Any suggestions on getting the FIND button to work and display in the search results area would be handy as well.