| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing sql record to cell value
A better approach: Sub test() Set a = Range("a1:a3").Find(dbValue, LookIn:=xlValues) If a Is Nothing Then MsgBox "not found" Exit Sub End If End Sub Manges -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=37701 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
| Set cell to record date when adjacent cell is filled AND NOT RESET | Excel Worksheet Functions | |||
| how do i record changing cell data (cell is dde linked) | Excel Discussion (Misc queries) | |||
| Record Macro - Record custom user actions | Excel Programming | |||
| Need help autopopulating next new record with previous record data | Excel Programming | |||
![mangesh_yadav[_270_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
