Hi All,
I'm trying to to get the hold of this issue, I know it basic VBA but I'm not an expert.
could anyone help me?
here is my dilemma:
I would like to show the number from a specific row that correspond with the selected cell.
for example I have values in column A, I would like to get the value from column A that correspond to the cell that i selected.
What do you mean by "show the number"
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I have numbers in Column A, and what I would like to achieve is: whenever I select a cell from column B and beyond, I would like to get the number from Column A that correspond to the selected cell.
I understand what value you're interested in. My question was more about what exactly do you mean by "show" and "get". Those terms are ambiguous.
The code above shows the value from Column A in a message box.
This gets the value and puts it in the variable x.
x = Range("A" & ActiveCell.Row).Value
Ahhh. Sorry, im new to the VBA terms.
what i meant by "show" and "get" is to write the value from column A into the corresponding cell which I selected
- Right-click on the sheet tab
- Select View Code from the pop-up context menu
- Paste the code from below in the VBA editor
Please Login or Register to view this content.
Thanks a lot AlphaFrog, you just saved me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks