Xl-X and Xl-2003 compatibility

[hdtvguy]

Hi:

I am having a problem with spinner buttons not working in Excel-X.

I am porting from a PC, an Excel 2003 workbook with VBA code to a
Apple laptop running Excel-X. The spinner buttons show on the form and
their code shows in the Visual Basic editor but they don't spin on the
Apple.

e.g.

Private Sub SpinnerButton1_Change()
'Do some stuff here'
End Sub

·Button appears on the Apple and PC
·Code appears on the Apple and PC
·Button only spins on the PC

Any ideas?
Thanks

 

[JE McGimpsey]

I am having a problem with spinner buttons not working in Excel-X.

I am porting from a PC, an Excel 2003 workbook with VBA code to a
Apple laptop running Excel-X. The spinner buttons show on the form and
their code shows in the Visual Basic editor but they don't spin on the
Apple.
<snip>
Any ideas?

Your spinners are ActiveX controls from the Controls Toolbox. ActiveX
does not run on Macs. Change your spinners to spinner controls from the
Forms toolbar instead.

 

[hdtvguy]

Your spinners are ActiveX controls from the Controls Toolbox. ActiveX
does not run on Macs. Change your spinners to spinner controls from the
Forms toolbar instead.

Thanks, that did the trick. One last question. Now that I use a Form
Tool spinner to change values in its associated ActiveX TextBox, the
Format command seems not to work anymore. Whereas "MyVariable =
Format(0, "$0.00")" displayed a dollar value for the variable sent by
the ActiveX spinner to its TextBox, the same TextBox now displays a
General format when it receives the value from the Form Tool spinner.

Thanks again