Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching in Excel spreadsheet Tohvie Excel Discussion (Misc queries) 2 March 18th 10 10:39 PM
Formula for searching spreadsheet Lozza65 Excel Worksheet Functions 7 November 28th 07 11:35 PM
Searching a spreadsheet Ryan Excel Discussion (Misc queries) 4 July 24th 06 11:57 PM
searching a spreadsheet antro Excel Programming 2 October 27th 04 08:47 PM
Searching a spreadsheet Darren[_6_] Excel Programming 2 September 24th 03 06:03 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"