View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
antro[_5_] antro[_5_] is offline
external usenet poster
 
Posts: 1
Default 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