Userform Not Working on Mac(Coded in PC)? Is there a difference?

[Lukej44]

Hi,

I have a userform that I created and it runs perfectly on my PC. When I send it to my coworkers Mac with the latest Office 365, and Excel 2011 the userform pops up and will give me the option to use the functionality(checkboxes, textboxes, ect.), but not get the references to the numbers needed for the calculations located on sheet2.

Trying to get this calculator worked out for Macs so I can push this out to our Reps in the Field.

Any info will help!

 

[RoryA]

but not get the references to the numbers needed for the calculations located on sheet2.

What exactly does that mean? VBA is not 100% compatible between Mac and PC but it's hard to comment without more information.

 

[Lukej44]

So I've tried 2 different way so far. The first had about 25 variables that could be 1 of 4 numbers based on what type of structure they chose and what type of currency was selected. These were simple modifier values. This was all done in VBA code. The second way I tried was to put the values in sheet2 and hide it.

this is what I currently have right now.

Dim index As Integer
index = AppBox.ListIndex

Select Case index
Case Is = 0
IAWI = Sheet1.Cells(66, 2).Value
WindowsPhone = Sheet1.Cells(67, 2).Value
BlackBerry10 = Sheet1.Cells(68, 2).Value
desktop = Sheet1.Cells(69, 2).Value
meetings = Sheet1.Cells(70, 2).Value
AR = Sheet1.Cells(71, 2).Value
AAR = Sheet1.Cells(72, 2).Value
IM = Sheet1.Cells(73, 2).Value
Gam = Sheet1.Cells(74, 2).Value
Beac = Sheet1.Cells(75, 2).Value


What happens is when a checkbox is checked, the value is supposed to be returned to the textbox associated with that value. It will come back as 0 everytime. I have a print cost summary as well and it still works but all my values are 0 still.

 

[Lukej44]

So I used a previous file that had sheet10 as the first one and that was it. I don't know why they ended up there but I didn't catch it until I already had it done. I technically call sheet1, "sheet2" for reference. I wonder if the sheet numbers would change going to a mac from a PC. For example, what if the mac version called sheet1 sheet2 instead?

 

[RoryA]

You are using codenames which shouldn't change unless the user changes them in the VB editor.