I have used the code below to copy a cell value to the linked cell of a combobox (this code is an excerp of about 60 cases)
the problem is that the cell value being copied contains a formula such as
=IF(ISTEXT(Properties!AF8), HYPERLINK("#geninfopage", Properties!AH8), IF(ISTEXT(Properties!AK8), HYPERLINK("#geninfopage", Properties!AL8), ""))
which can result in the blank cell depending upon whether a search gives a result. If a blank cell is copied to the linked cell of the combo box an error results.
what I would like to build in is a error check to identify if a cell is empty before executing the code (or not executing)
eg
if worksheets("frontend").range("C11").value <> ""
then execute
else do nothing
Code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Address
Case "$C$11"
Worksheets("front end").Range("chemlinkcell").Value = Worksheets("front end").Range("C11").Value
Case "$C$12"
Worksheets("front end").Range("chemlinkcell").Value = Worksheets("front end").Range("C12").Value
End Select
End Sub
Display More
Thankyou for any help
Justin