Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching in Excel spreadsheet | Excel Discussion (Misc queries) | |||
Formula for searching spreadsheet | Excel Worksheet Functions | |||
Searching a spreadsheet | Excel Discussion (Misc queries) | |||
searching a spreadsheet | Excel Programming | |||
Searching a spreadsheet | Excel Programming |