searching a spreadsheet
 

Still working my search feature, but I'm getting closer on using th
enter key to equal a button click, even if you are still in the tex
box. I have it working for one case but not the other.


Code
-------------------

Private Sub txtCWIC_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Select Case KeyAscii
Case 27 '27 is ASCII value for Esc key
btn_Cancel = True 'ends the program
Case 13 '13 is ASCII value for Enter key
btn_Search = True 'performs the search
End Select
End Sub

-------------------



Antr

--
antr
-----------------------------------------------------------------------
antro's Profile: http://www.excelforum.com/member.php...fo&userid=1577
View this thread: http://www.excelforum.com/showthread.php?threadid=27293