Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
KeyPress (VBA)
Name: Kevin Date: December 19, 2002 at 06:59:43 Pacific OS: 2000 CPU/Ram: enough
Comment:
I have multiple forms in a project and what I would like to do is hit the Escape key on every form and the form hides. What code would I use to do this and where can I set it so that I dont have to do this code on every form.
Name: Madman Date: December 19, 2002 at 11:42:51 Pacific
Reply:
What do you mean by 'hides'...like, be invisible? You could do it but you would have to have some code in each form to trigger the event. Question...how are you going to 'unhide' the forms?
0
Response Number 2
Name: cykage Date: December 20, 2002 at 20:23:04 Pacific
Reply:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyEscape Form1.Hide End Select End Sub
Summary: i am new to VBA and need a VBA program that i can call in excel. this program would solve an equation such as one of time dilation: t = t0/sqrt(1-(v/c)^2) i actually have to do this for a number of f...
Summary: hay there stuart thankyou for your reply the question has been given to me to do over the summer by as you gessed an old teacher he has given powerpoint sheets to us with upto date examples but are us...
Summary: I'm trying to save an excel spreadsheet with the filename of K&N.csv but when I try and do this from within my macro, excel crashes when the workbook is closed. I can save the file and close the workb...
0 
