VB Help: Double Clicking a cell and different cells pdating

**nworner** · 01-15-2014, 03:21 PM

Hey everyone,

I am trying to write a VB code that when I double click on a particular cell, two cells on a different tab update to the column heading and row heading. For example, in the data below, if I double click the cell in D3, I should get the cell "B1" in another tab to update to "b" and the cell underneath it, "B2" to update to "2".

PHP Code:


 Sheet1                                                                                       Sheet2
 
            A          B           C            D           E           F                              A            B         C
        1                           1            2            3          4                          1   Letter:     b
        2             a                                                                               2   Number:   2
        3             b                                                                               3
        4             c
        5 
        6

Any help would be very useful. Please keep in mind that I have never used this help forum before, so any advice on how to use this forum better would be helpful as well. Thank you all!

**gsnidow** · 01-15-2014, 03:38 PM

Welcome to the forum. I, for one, am not clear on the logic you are trying to incorporate. For example, what is supposed to happen if you double click "D4"? What is the realtionship between the cell you are clicking, and the cells that are updating?

Greg

**nworner** · 01-16-2014, 12:19 AM

Greg,

Thanks for the quick reply. I have a table in my first tab. Lets say that the row headings are a,b,c and the column headings are 1,2,3,4. My goal is to create a macro that when I double click on the cell that corresponds to the cell row and column from the table, I will get two cells on a separate tab that update to what the row value was and what the column value was.

So I want to relate the row heading and the column heading for a particular cell to the output cells. So in the example that I gave earlier, when I double click the cell "D4" I want the letter to be c and the number to be 2. Because "D4" corresponds to row c and column 2 from my table.

Hopefully this makes more sense. I really appreciate your help!

It might make more sense if you open the Excel sheet attached. There is no coding in it, but it shows the layout of what I am talking about and the comment shows what I want as a result.

Once again thank you for the help!