Clock problem

[007]

My problem is probably quite simple, as i am only a beginner with excel. But here goes, im attempting to use formula's and functions to create a very short football game, based on IF's and VLOOKUP's, particularly. However i need for a cell to +1 every time i press ENTER/DELETE to recalculate the entire sheet (if that makes any sense?) Is their a quick solution, or even a long solution?

ANY help what so ever would be great.

Steve

 

[stickboy]

Hi,

I studies Business in the B block mainly. I graduated last july, and lived in swindon for my sandwich year and last year, and so I havent been to Bristol for a hile.

Is the Steam Rock bar still there?

Luke,
How do I revert the delete key to its normal use?

Thanks
Stuart

 

[DonkeyOte]

done

 

[stickboy]

Can either of you tell me how to get my delete key working again?

thanks
stuart

 

[DonkeyOte]

ha ha

Create a macro in this workbook - code

Application.OnKey "{DEL}"

will reset - run to activate.

That's why a workbook close event is needed as it's an application event not workbook.

 

[stickboy]

sorted cheers.

I have put in a workbook close event to run that code!!
Thanks

 

[007]

lasw10 - did you get my 'PM' - need to know how to use the email you sent me? i know nothing about how to use visual basic, or anything about macros, can you run through it with me, please?