This site has proven to be an invaluable resource, thankyou to everyone who posts both questions and responses. This is the first time I have posted a question although I have had a bit of a look I cant guarantee it hasnt been asked before, if so please point me in the right direction.
I have developed a basic front end for a simple database using the vlookup and index search functions.
Within the front end I have an if function that shows a hyperlink if a search cell is used and a result is obtained
=IF(ISTEXT(Properties!X2), HYPERLINK(CONCATENATE("#", Properties!X2,"hazard"), Properties!Z2), ""))
I also have a combobox that you can select from.
1. Is it possible to have the combobox linked-cell changed to a particular cell (eg. x2) value when someone clicks on the hyperlink cell (only if the hyperlink is active). 2. Does it require VBA or can it be managed using a function?
3. will it update the combobox?
Thanks in advance