Excel help - where is the...

Our "pub" where you can post about things completely Off Topic or about non-silent PC issues.

Moderators: NeilBlanchard, Ralf Hutter, sthayashi, Lawrence Lee

Post Reply
Wedge
Posts: 1360
Joined: Tue Mar 25, 2003 10:59 pm
Location: NorthEast Arkansas, USA

Excel help - where is the...

Post by Wedge » Wed Jul 30, 2008 4:53 pm

I am trying to learn a bit about Visual Basic with Excel. Where is the "procedure combo box" ?

To put this in context, view this following simplified tutorial that I am following. Scroll down to a heading entitled:
Practical Learning: Generating A Keyboard Event.

It states the following:
1. In the Object combo box, select txtFullName
2. In the Procedure combo box, select KeyDown and observe what the code of the event looks like:

Code: Select all

Private Sub txtFullName_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

End Sub
My question is: WHERE is the procedure combo box? I would like to see this code generated for the sake of following the tutorial proper.

yefi
Posts: 134
Joined: Tue Jun 12, 2007 3:19 pm
Location: UK

Post by yefi » Thu Jul 31, 2008 7:27 am

Press F7 to view the code behind the form. The box with the events is:

Image

Wedge
Posts: 1360
Joined: Tue Mar 25, 2003 10:59 pm
Location: NorthEast Arkansas, USA

Post by Wedge » Thu Jul 31, 2008 8:17 pm

Thank you. Much appreciated.

Post Reply