CODEWITHSUNDEEP
vbaexcel
theheater89
theheater89

Reputation:

VBA Programming in Excel

I am new to programming in Excel. I have done very little Visual Basic. What I would like to do is check a column on one sheet in Excel and compare all the values to a column in a different sheet in Excel. Now the problem is, is it possible that when i click on one of the cells it is "linked" to the other and takes me to the matching cell. I would like to have this implemented into the spread sheet and not be a "macro". If anyone can help it would be much appreciated.

Upvotes: 0

Views: 684

Answers (1)

Atmocreations
Atmocreations

Reputation: 10061

"macro" and "implementation in spread sheet" is nearly the same. the macro is, depending on how you do it, stored in the spreadsheet-file (.xls)

you can get the content of a cell by reading 

Range("A1").Value // Any cell-reference is valid here.

If you want to read an entire column, you need to use some kind of loop.

the linking you're talking about could be done with the event Worksheet.SelectionChange. e.g. following skeleton:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

you may now fill what should happen when the selection has changed. With Target.Column and Target.Row you may read the row and do the appropriate tests.

You can switch the View on a special Sheet using the Worksheet.Activate-Method which brings on top the worksheet you call the method on.

hope this clarifies a bit... if you need details, i will do some research...

regards

Upvotes: 4

Related Questions