ADD creating & edditing UserForm in Excel VBA for MAC
it is not possible to creating or editing UserForm in Excel VBA for Mac.
ne stavav murshi
DEFINE A LIST AND WITH THE FOR-NEXT CYCLE ADD (EXAMPLE
Set List1 = Range (Cells (2, 1), Cells (2, 1) .End (xlDown))
For k = 1 To List1.count
UserForm1.ComboBox1.AddItem List.Item (k)
UserForm1.ComboBox1.RowSource = "Sheet .........
Microsoft, Don't leave VBA in limbo. Either embrace it again or kill it! You are not helping developers.
pls go over there and vote - same issue-ticket.
Najwa Rahal commented
Please add Data Form Entry to Mac.
How come it is not available ?
Please add this to Mac!!
I just created an excel app on a Windows machine that incorporates a user form but when I send it to my client who uses a mac the form appears on his machine but some of the controls do not work properly. Specifically the Rowsource attribute for a combination box control does not get applied. Anyone have any suggestions as to how one might get around this?
Clive Marsh commented
I can't believe that this step has been taken. Has anyone come up with another solution?
Is this some sort of joke? The most useful aspect of VBA is missing? How come there are only 8 votes for this - have i entered some kind of twilight zone?
Now that Excel 2019 forMac does not have the Data Form creator, this makes entering data into legacy worksheets very time-consuming. Willthis be re introduced or are there VBA work arounds out there?