alfwong1
03-17-2003, 04:23 PM
<file:Contact.xls>
Sheet1: column A eg A1..... Axxxx
when i double click, it will retrieve all the record from Sheet2 Column A
eg. ASP, VB....
When i select VB Then it will fill in the record to Column B
Now A1 = VB and B1 = A1VB.com
Sheet2
A B
1 ASP 4Guysfromrolla
2 VB A1VB.com
3
4
5
6
7
Thank you
Wamphyri
03-17-2003, 09:39 PM
You might want to try re-explaining that.
alfwong1
03-17-2003, 09:46 PM
You might want to try re-explaining that.
What i try to do is
1.
when i double click on the column A of 'Sheet1', it will list all the record from column A of 'Sheet2'.
thx
Legend
03-17-2003, 10:39 PM
Do you want to copy all the data from column A of Sheet 2 when you double click column A of sheet 1??? :confused:
alfwong1
03-17-2003, 11:23 PM
Do you want to copy all the data from column A of Sheet 2 when you double click column A of sheet 1??? :confused:
No .. i just wanna to list them and choose only one in the Sheet 1
for example
when i double click on A1 it will list all and select only one
same as A2... and so on
thx
EACutter
03-18-2003, 10:57 AM
No .. i just wanna to list them and choose only one in the Sheet 1
for example
when i double click on A1 it will list all and select only one
same as A2... and so on
thx
I too am still unclear on what you are trying to accomplish.
I'm not aware of a VBA command that responds to double clicking on a cell (though there may be such an animal), only on entry.
However, if you are trying to pick from a list I suggest you try Excel's data validation function. Select Validate... under the Data menu and under the settings tab in the Allow: box, select List. then under Source: put in A:A from on Worksheet 2.