Mackintosh - Excel users

  User-87348949-8D17-47EF-BF40EE49948F5B71 08:50 11 May 2004
Locked

I am having a problem with code for an inputbox. The following line has been stripped from a larger code module and found to have the same error. Compile Error: Syntax Error!

Sub Test

i = inputbox("Trial","Test")

End Sub

I tried to Dim the i to no avail, any help on this disparity between the Mac and MS versions of Excel would be appreciated.

  VoG II 09:30 11 May 2004

Clutching at straws here but have you tried

i = inputbox(prompt := "Trial", title := "Test")

Thanks for the suggestion, it may be that the Mac version of Excel is far stricter on the use of 'variables'.

I have sent the suggestion to the USA for verification, either way I will post back.

Gordon

No Mackintosh users online?

Last bump

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?