User Form

[How_Do_I]

Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to modify a user form that I’m using to enter half time and full time football scores.
<o> </o>
I enter my scores by using Spin Button… so for example if the half time score was 3-2 I’d enter that using Spin Button 1 and 2 seeing my 3 and 2 in Text Boxes 1 and 2… however, if there were no second half goals I then have to enter 3 and 2 using Spin Buttons 3 and 4 to see 3 and 2 in Text Boxes 3 and 4…
<o> </o>
What I want to know is, can my second half text boxes (3 and 4) = my first half text boxes (1 and 2) and then be amended by the Spin Buttons (3 and 4) IF there are second half goals please?

 

[EXCEL-lence]

Yeah

I think the trick to this is having a couple of "ghost" text boxes which hold the second half goals - which are then added to the first half to give the total

1st Half HOME AWAY

2nd Half HOME AWAY (will equal 1st half + ghost box result)

the ghost box result is affected by the spin button

That's how I'd do it anyway

Please help support me by visiting www.excel-lence.info

 

[EXCEL-lence]

p.s. I didn't realise you were a Chelsea fan (United all the way )

 

[How_Do_I]

Yeah

I think the trick to this is having a couple of "ghost" text boxes which hold the second half goals - which are then added to the first half to give the total

1st Half HOME AWAY

2nd Half HOME AWAY (will equal 1st half + ghost box result)

the ghost box result is affected by the spin button

That's how I'd do it anyway

Please help support me by visiting www.excel-lence.info

I'm not sure what you mean, sorry... If the HT and FT score was 3-2, I only want to enter 3 - 2 once as opposed to twice which I currently do...

Using the 3-2 HT... if the away team scored in the second half would I be entering 0 1 or 3 3 on the spin buttons... I want to enter 3 3.

 

[How_Do_I]

p.s. I didn't realise you were a Chelsea fan (United all the way )

What are your thoughts on losing Barton? That is the right United, yes???

 

[EXCEL-lence]

I'll do you a sample - hang on

 

[EXCEL-lence]

and pffttt not Newcastle !!

 

[How_Do_I]

Leeds? LOL

 

[EXCEL-lence]

www.excel-lence.info/ffe.xlsm


Is this how you mean?

 

[How_Do_I]

Thanks, I downloaded that but nothing happened... I'm using xl 2003 here.