I have a table where the third column contains stock symbols that are converted into the stocks data type from 365. For the first two symbols entered (on rows 1 and 2 beneath the header) the user must enter the symbol, return to the cell and click the Stocks button on the data menu. The third entry and beyond are converted automatically by Excel with no code or formatting. I plan to compile this workbook into an exe that does not show the ribbon at all. I therefore want to automate this first two symbol conversion operation.
I found the method (in the title) to convert the cell but the symbol must be entered before the method is invoked. Do I have access to the method or property that Microsoft uses for that third symbol entry forward? If not, I guess I will need a macro for the worksheet change event as in:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Set ws = Worksheets("Portfolio Trades")
?????. ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:="en-US"
End Sub
Where ????? = third cell in the bottom row of ws.ListObjects("Trades")
Thank You
I found the method (in the title) to convert the cell but the symbol must be entered before the method is invoked. Do I have access to the method or property that Microsoft uses for that third symbol entry forward? If not, I guess I will need a macro for the worksheet change event as in:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Set ws = Worksheets("Portfolio Trades")
?????. ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:="en-US"
End Sub
Where ????? = third cell in the bottom row of ws.ListObjects("Trades")
Thank You