Excel on a Mac?

[arkusM]

Try Unix!

Oh oh that would put me in geek territory!!
Can't do that!

I have friends that are big into Unix/Linix etc.
VBA is really my first true foray into the programing world and I feel as though I am drinking from a fire hose!

 

[sous2817]

The one thing that I could never get to work in 2002 (XP) and works fine in 2003 is from http://www.contextures.com/xlDataVal14.html. Every time in 2002 it would crash, but the same file in 2003 worked fine.

'Optional code to move to next cell if Tab or Enter are pressed
'from code by Ted Lanham
Private Sub TempCombo_KeyDown(ByVal _
        KeyCode As MSForms.ReturnInteger, _
        ByVal Shift As Integer)
    Select Case KeyCode
        Case 9 'Tab 
            ActiveCell.Offset(0, 1).Activate
        Case 13 'Enter 
            ActiveCell.Offset(1, 0).Activate
        Case Else
            'do nothing
    End Select
End Sub

Sorry, I know that was way, way off topic but it's always bugged me...

 

[RoryA]

I.e., I could never get back to how the Address Of Operator would normally work with a stand-alone version of Office '97.

My memory must be failing me - I didn't think AddressOf worked at all in 97?

 

[RoryA]

Oh oh that would put me in geek territory!!
Can't do that!

I have friends that are big into Unix/Linix etc.
VBA is really my first true foray into the programing world and I feel as though I am drinking from a fire hose!

What do you suppose your Mac is basically running?

 

[NateO]

Don't tell that to Michael Kaplan!

http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19

That was one of my problems, my XP version of Excel took control of how VBA worked on my box, even in my '97 install (I think), and I couldn't recreate what he did there.

 

[NateO]

What do you suppose your Mac is basically running?

 

[RoryA]

But that's AddrOf, not AddressOf!

 

[NateO]

Okay, you got me.

That's what I meant, though... It's easier to say 'AddressOf' than 'The Ken Getz/Michael Kaplan Workaround for AddressOf as it applies to VB[A] 5/Office 97'.

 

[arkusM]

What do you suppose your Mac is basically running?

I know, I know it is based in Unix, but I don't have to know Unix to make it work.
My friends that use Unix have Macs for that purpose...

Oh oh that would put me in geek territory!!

That was definetly tongue and cheek!! LOL
EDIT: But you will not catch me using the terminal any time soon!
I feel out of my depth in VB.

 

[RoryA]

Yeah I knew what you meant! I know that from Ken Getz' work; had forgotten that Michael Kaplan was involved. Can't say I ever had a use for it back then, but thought it was interesting!