Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a custom function that uses arguments from the user's worksheet to
find data in an external Access database using ADO, then return it to the relevant cell. It works fine, but I want to be able to ensure that the custom function leaves the cell value *untouched* (rather than returning an error value) if the VBA cannot make the connection to the Access database (e.g. if the user can't access the database for some reason). I've tried using Application.Caller to get the cell's original value, but this doesn't seem to work. Can anyone help? Thanks, SB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom addin gives #name? errors | Excel Worksheet Functions | |||
To leave a cell blank following an "IF" function | Excel Worksheet Functions | |||
referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
using IF function to copy, but leave populated cell alone | Excel Worksheet Functions | |||
Communicating errors from a custom function in an add-in | Excel Programming |