Data Entry Forms

[Sutek]

Hello all,
this is fairly basic stuff, so please be patient with me, as i am really new to this and keen to learn.
I have a spreadsheet, worksheet or whatever its best title is, which has a list of customers and details for each. I can enter data onto this sheet easily, however, I want to make it idiot proof (yep my business partner knows less about spreadsheets than i do). I want to be able to enter all the data, for a particular customer and their job, from a form. I also want this form to be permanently visible, in fact it would be better if the form was the only thing my partner could see (to remove the temptation to play with the spreadsheet).
So my questions are these:
How do i create a permanent form to enter the data? and can i get it to automatically show up, as at least the first screen?
I have more than 32 columns of data (not all of which, has to be populated from a form) Excel keeps telling me i have to many fields for a form.
Can i split the data up and have it all reference back to each other? e.g. have several forms that populate one sheet with different sets of data. Such as, one form for customer details and another for their jobs and yet another for their remaining jobs.
I've included the data as it appears in my spreadsheet.
Any advice on my best course of action would be appreciated
thanking you all in advance
Cheers
Cal

REF	Date	First Name	Surname	Title	Street Address	Suburb	State	Postcode	Job Description	Description 1	Quantity 1	Unit Price 1	Cost 1	Description 2	Quantity 2	Unit Price 2	Cost 2	Description 3	Quantity 3	Unit Price 3	Cost 3	Description 4	Quantity 4	Unit Price 4	Cost 4	Description 5	Quantity 5	Unit Price 5	Cost 5	Description 6	Quantity 6	Unit Price 6	Cost 6	Description 7	Quantity 7	Unit Price 7	Cost 7	Description 8	Quantity 8	Unit Price 8	Cost 8	Description 9	Quantity 9	Unit Price 9	Cost 9	Description 10	Quantity 10	Unit Price 10	Cost 10	Subtotal	GST	Total
THOGE	16-January-2015	Geoffrey	Burns	Mr	blah	Wavel Heights	Qld	4012	Storm Damage Repairs	Repair of broken leadlight panes in four(4) leadlight panels and one(1) door leadlight	9	$0	$0	Site Preperation	1						$0.00				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00	$0	$0	$0
HOOLJ	21-January-2015	LJ	HOOKER		blah	Wooloowin	Qld	4030	Storm Damage Repairs	Relead of damaged leadlight panel, including replacing broken panes. Damage too extensive for onsite repair	1	$0	$0	Site preparation and removal of leadlight	1	$	$	Installation	1	$0	$0	Lead Handling	1	$0	$0				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00	$0	$0	$0
GRILY	21-January-2015	Lyn	Baker	Ms	blah	Red Hill	Qld	4059	Storm Damage Repairs	Releadl centre leadlight panel due to extensive storm damage	1	$0	$0	Relead RHS leadlight panel due to extensive storm damage	1	$	$	Clean and Polish LHS leadlight panel	1	$0	$0	Site preparation and leadlight removal	1	$0	$0	Installation of all leadlights	2	$0	$0	Lead Handling	1	$0	$0	Cost of Scaffolding to remove leadlights	1						$0.00				$0.00				$0.00		$0	0
DESEL	16-January-2015	Elizabeth	Jones	Ms	blah	South Brisbane	Qld	4101	Storm Damage Repairs	Site preparation and removal of leadlight	1	$0	$0	relead damaged leadlight	1	$	$	rebuild damaged areas on leadlight	1		$	Installation	2	$0	$0	Lead Handling Fee	1	$0	$0				$0.00				$0.00				$0.00				$0.00				$0.00		$0	0
MATSA	27-January-2015	Sally	Smith	Ms	blah	Highgate Hill	Qld	4101	Storm Damage Repairs	Site preparation and removal of leadlight	1	$0	$0	Relead damagedmain leadlight door panel	1	$	$	Relead damaged secondary leadlight panels	2	$0	$0	Installation	3	$0	$0	Lead Handling Fee	1	$0	$0				$0.00				$0.00				$0.00				$0.00				$0.00		$0	$0
MATSA	27-January-2015	Sally	Smith	Ms	blah	Highgate Hill	Qld	4101	Storm Damage Repairs	Onsite repairs of broken leadlight panes	4	$0	$0	Site Preperation	1	$0	$0				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00				$0.00		$0	$0

<colgroup><col><col><col span="3"><col><col><col><col><col><col><col span="3"><col><col><col><col><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[OriginalCarey]

Hi mate

I would seriously suggest reading the following article:

Excel VBA Userform - Easy Excel Macros

That's how I learnt how to make my userforms a long time ago. Follow that guide, only using the boxes etc that you'd need, and name them accordingly.

Very very easy guide to follow.

 

[OriginalCarey]

Also just a note, it is very basic stuff but something like this would be easier for you to read a guide and "do it yourself" with own naming conventions as opposed to someone "doing it all for you", that way if something goes wrong for a userform like that it'll be easier for you to have an idea what happened.

Give updates how you're getting on, and let me know. If you're really stuck I can make the userform for you and code it up.

 

[Sutek]

Thanks for the help mate. I had a look at the link and its spot on what i was looking for. I'll work through the tutorials and modify them as needed. I was looking to do this all myself, for control, as well as getting familiar with all this.

 

[OriginalCarey]

No problems man, that tutorial will set you up nicely, and as its all handmade you can make it look at pretty as you like