cscribner
09-12-2005, 08:51 PM
I'm comingto grips with the fact that macs don't support the .rowsource property. I have this lovely dynamic range that I want to put into a userform combobox, and it looks like I have to resort to an AddItem process. But I seem to be encountering a larger problem. I don't seem to be able to select specific sheets or cells at all from my userform. Is that really the case?
Here's the code I'm trying to use:
Private Sub UserForm_Initialize()
Sheets("Sheet1").Select
Range("TestListHeader").Select
Selection.End(xlDown).Select
Dim i As Integer
i = ActiveCell.Row
MsgBox ("The last row number in this list is: " & i)
End Sub
Obviously, I'm starting down the path of finding out how many items (rows) I need to add so I can run a neat little additem loop. But I'm getting errors on the very first row, where it's trynig to select the sheet, or the named cell.
How do you reference cells from VBA on a mac?
Here's the code I'm trying to use:
Private Sub UserForm_Initialize()
Sheets("Sheet1").Select
Range("TestListHeader").Select
Selection.End(xlDown).Select
Dim i As Integer
i = ActiveCell.Row
MsgBox ("The last row number in this list is: " & i)
End Sub
Obviously, I'm starting down the path of finding out how many items (rows) I need to add so I can run a neat little additem loop. But I'm getting errors on the very first row, where it's trynig to select the sheet, or the named cell.
How do you reference cells from VBA on a mac?