RefEdit control 1

[VBAva]

Hello

ok i found the RefEdit control but am not quite sure how to do what i need so i require a little help please.

1. Make sure that only one cell is selected
2. Check for a value in a cell relative to the one selected
Offset (4,0)

thank you all

 

[combo]

Range(RefEdit1.Value) returns range selected with RefEdit1 control. You can proceed with this like regular range:
[tt]Private Sub RefEdit1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
MsgBox Range(RefEdit1.Value).Cells.Count
End Sub

Private Sub RefEdit1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
MsgBox Range(RefEdit1.Value).Offset(4, 0).Value
End Sub[/tt]

combo

 

[VBAva]

cool, cheers
i think that could be very useful, have a star