Form - Mac computer - Drop Down List

[VictorHugo]

Hello,

I m at a form, and there is a drop-down list. When clicking on a drop-down list it searches and results from the names of the cells. I did this formula because I had seen that Excel for Mac does not recognize the UsedRange.Rows command.

Dim oneCell As Range


For Each oneCell In Range("A1:A10")
ComboSearch.AddItem oneCell.Value
Next oneCell

The question is, when clicking on a name in a drop-down list, all the form should return the values of the other cells, but I don't know the commands in Mac in this part to substitute the Used.Range commands.

Private Sub InstructorName_Click()


Me.InstructorName.RowSource = "Sheet1!A:B"


totalregistre = worksheets("Sheet1").UsedRange.Rows.Count


For i = 0 To totalregistre


If InstructorName.ListIndex = i Then


InstructorName = Cells(i + 1, 1)
Specialization = Cells(i + 1, 2)
DateFrom = Cells(i + 1, 3)
DateTo = Cells(i + 1, 4)
HourFrom = Cellss(i + 1, 5)
HourTo = Cells(i + 1, 6)