VB in Excel
 

Hello Guys/Gals of Netsmog

A friend of mine whipped up a really cool VB tool in Excel. This tool gives you a question, you answer it, and it scores you. My question is he wants to set his "Check Answer" button to recognize a stroke of the [Enter] key. Meaning, he wants to hit [Enter] and it does the same thing as if he pressed the "Check Answer" button. Any ideas?? I know that in Java you would do something like:

<input type = "button"...>
onKeystrike (enter) "CheckAnswer"

or something like that, since I am rambling on needlessly and obviously don't know what the hell I'm talking about, I'll shut up and leave it to those of you that know this stuff.

Thanks,
Jordan Coffey

Re: VB in Excel
 

I am not really familiar with VB used in Excel, but in VB and in Access VB you have an "ON Click" event for buttons. You can put the code of what you want it to do there. (When the button is pressed, do something)

sub button1_Click()
  code goes here
end sub