Your first line in VBA code is "Private Sub Worksheet_SelectionChange(ByVal A_Target As Excel.Range)" whereas normal line is "Private Sub Worksheet_SelectionChange(ByVal Target As Range)". What is the difference?
Hello @user-ym3df5xx9w, There are differences between the two lines is the parameter type. Here, "ByVal A_Target As Excel.Range" specifies that the parameter is of type Excel.Range and is prefixed by the worksheet's class. To use explicit references to objects from the Excel library. Where "ByVal Target As Range" uses the generic Range type, which is implicitly understood to be from the Excel library within the context of VBA. If you are concerned with naming "A_Target" and "Target", it is simply the name of the parameter. In VBA, you can name parameters anything you like, as long as it follows naming conventions. Regards ExcelDemy
Interesting, but ultimately meh. Far more useful would be to have a floating cell synchronized with an input cell such that you can edit either and have the change reflected in both, without using VBA. (I know it's pretty simple to do with an ActiveX textbox, but as with VBA, I don't really like using ActiveX in any workbook I have to share.)
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
This is GOLD. Thank you so much.
Hello @jschwone2607,
You are most welcome. Thanks for your appreciation. Keep learning Excel with ExcelDemy!
Regards
ExcelDemy
Best channel to learn excel
Dear, Thanks for your compliments! Glad to hear that.
BRILLIANT, FAR REACHING HARD HITTING SPEECH TO THE MARK.
Dear, Thanks for your wonderful compliment! Your appreciation means a lot to us.
excellent............................😍😍😍😍😍😍😍😍😍😍🥰🥰🥰🥰🥰
Hello @raufali9265,
Thanks a lot. Your appreciation means a lot to us. Please stay connected with us.
Regards
ExcelDemy
Very informative
Hello @cholliday,
You are most welcome. Please stay connected with us.
Regards
ExcelDemy
You can use paste linked picture or the camera feature to achieve the floating view
Hello @KeithSwanzy,
Thanks for your amazing suggestions. Please stay connected with us.
Regards
ExcelDemy
Thank you very much
Hello @rshabsough ,
You are most welcome. Your appreciation means a lot to us. Please stay connected with us.
Regards
ExcelDemy
Your first line in VBA code is
"Private Sub Worksheet_SelectionChange(ByVal A_Target As Excel.Range)" whereas normal line is
"Private Sub Worksheet_SelectionChange(ByVal Target As Range)".
What is the difference?
Hello @user-ym3df5xx9w,
There are differences between the two lines is the parameter type.
Here, "ByVal A_Target As Excel.Range" specifies that the parameter is of type Excel.Range and is prefixed by the worksheet's class. To use explicit references to objects from the Excel library.
Where "ByVal Target As Range" uses the generic Range type, which is implicitly understood to be from the Excel library within the context of VBA.
If you are concerned with naming "A_Target" and "Target", it is simply the name of the parameter. In VBA, you can name parameters anything you like, as long as it follows naming conventions.
Regards
ExcelDemy
Interesting, but ultimately meh. Far more useful would be to have a floating cell synchronized with an input cell such that you can edit either and have the change reflected in both, without using VBA. (I know it's pretty simple to do with an ActiveX textbox, but as with VBA, I don't really like using ActiveX in any workbook I have to share.)
Dear, Thanks for your feedback! Unfortunately, the only way to achieve the requirements you mentioned is to use VBA.