How can i incorporate the Range syntax into Cell syntax

[NimishK]

Hello
How can i incorporate the Range syntax into Cell syntax

Private Sub CmbBooks_click()


Dim idx As Long
idx = CmbBooks.ListIndex
If idx <> -1 Then
  ws.Range("B" & idx +2 ).Value
End If
End sub

incorporating from above code into below seems not working

Dim idx As Long
idx = CmbBooks.ListIndex
 If idx <> -1 Then
         'ws.Cells(row, 2).value
          ws.Cells(idx +2 ,2).value
End If

Thanks NimishK

 

[RoryA]

That code doesn't really make sense. What are you trying to do with the value of the cell?

 

[NimishK]

That code doesn't really make sense. What are you trying to do with the value of the cell?

thanks Rory if the syntax for cells code as mentioned does not make any sense then the matter ends.
I was trying to incorporate the cell syntax as mentioned in post #1 instead of range. Trying to click on the value listed in combobox with cell syntax if possible

 

[Fluff]

This

ws.Range("B" & idx +2 ).Value

is the same as

ws.Cells(idx +2 ,2).value

You just aren't doing anything with it.