Make selection show userform

[dealer]

Hello,

I have set up 2 userforms and when i enter a value in cell L55 i want this to show the userform then for 10 seconds.

I have already a different userform opening for 10 seconds when the workbook opens,when i enter a number in cells
K2:L55 it calls a macro through worksheet change event.

But L55 been the last calculating cell i want this to then open the second userform when it receives a number,i can't seem to get this working.

Please any help would be great.

[davesexcel]

Try this,

Please Login or Register  to view this content.

Find out more here.
http://www.davesexcel.com/vbacodes.htm#858300135

[dealer]

Thanks very much Dave.