Return selected cell from Combo box

So i have a sheet which will grab a different record from a db and displays it on a page, it is then supposedly editable and can be altered and then saved back to the db.. this works ok at the mo :-)

problem is when i use a form of validation which involves a combo box it reloads all my data, which i don't really want!

Please Login or Register  to view this content.

i need something a bit like that... only there is no command such as
If Target.Address = Cells(2, 7).Address Then


anyone know the correct syntax?

thanks

hmm well basicaly i have a combo box which picks up validation lists and uses these as a form of automcomplete!


a better code that i need might be something like

If TempCombo.LinkedCell = Cells(2, 7) Then

but this doesn't quite work....
could be in a pickle here

i'll see if i can upload a sheet but has a bit of sensitive data in

Originally Posted by ChemistB

I always use the Intersect method

Please Login or Register  to view this content.

Does that work for you?

hi! i tried this but got a compile error, type mismatch!


what does that mean?

thanks

hmm.. an upload is going to error out as the connected db will not be found

i can give you a code dump instead!

Please Login or Register  to view this content.

thanks so much guys

Another way... ignore all my rubbish code..

how would you go about checking if the target of a combo box was the currently selected cell?