tinumathews
New Member
Hi, This is a bit akward stuff. This is an excel sheet. I have row, say A2 to Z2 filled up with alphabets starting with A to Z. I have another cell, say A3 displaying the active cell value. the code i have used is Range("A3") = ActiveCell.Value in the Selection change of the worksheet. Now i move the selection from A through Z the cell A3 displays the active cell value.
My requirement is - I have an input box which takes a name or a value, say "tinu" and save it in a variable, say "NameVar". When i move my selection from A through Z this should check for the first alphabet in "NameVar" and display it in the cell A3. As this word has 4 alphabets, i would be moving my selection from A to Z four times to get all the alphabets in the cell.
I am unable to do this as my excel skills does not allow me to do it
.
My first question is, is this possible? if yes then i would need your help. This would be of a great help.
Note: Its is not necessary that it should show up in the cell. It also can have a variable where it saves then displays, but its good if we have the word running up in the cell as we scroll the selection.
Thanks and Regards,
Tinu Mathews
My requirement is - I have an input box which takes a name or a value, say "tinu" and save it in a variable, say "NameVar". When i move my selection from A through Z this should check for the first alphabet in "NameVar" and display it in the cell A3. As this word has 4 alphabets, i would be moving my selection from A to Z four times to get all the alphabets in the cell.
I am unable to do this as my excel skills does not allow me to do it
.My first question is, is this possible? if yes then i would need your help. This would be of a great help.
Note: Its is not necessary that it should show up in the cell. It also can have a variable where it saves then displays, but its good if we have the word running up in the cell as we scroll the selection.
Thanks and Regards,
Tinu Mathews
