VBA on Excel 2004 Mac

[Nandezx]

Hi all,

I've just started a new job where Mac OS X is the platform used for all
their computers. My work involves using Excel a great deal, but i'm having
some troubles getting adjusted to the Mac version of Excel, so I would
greatly appreciate it if someone could help me out on the following points.

1) In Excel 2003, there was a "Control Toolbox" that could be placed on the
toolbar - it included icons to help design forms. Specifically, i'm wondering
why the assumed Mac version of this Control Toolbox a) doesn't have an icon
to insert a text box and b) automatically links all the code to the Modules
section instead of the Sheets when I go into the VB area.

Please enlighten me on how to insert a text box, how to easily modify the
properties of each of objects that I insert (such as a button, combo box or
list box) and how to make it such that the Office 2004's VBA functionality is
more easily accesible similar to Office 2003's.

Also, what does "Design Mode" actually do in Excel 2004? I know what it does
in 2003, but it doesn't seem to be the same at all. Maybe i'm just missing
something.

Final thing, I've always found that autofill thingy on Office 2003 useful.
The little function that brings up a list of possible
objects/methods/extensions when you're writing VBA code. For example, when I
start typing "ActiveSheet.", a list would come up of all the possible
endings. Is that gone, or do I need to activate that somehow?

I'm sorry if that seems a little too much, but I'm somewhat desperate to get
to know this better soon enough since I have a project due on it by the end
of the week. So far i'm preferring to use 2003, but my employer won't allow
me to bring a notebook using a Windows platform...

Thank you in advance!

Kind Regards,

I N Juwono

 

[NickHK]

Remember that all the controls on the "Controls Toolbar" are ActiveX
controls - MS COM technology - and as such not applicable to a Mac platform.
You still have the Forms controls, which are run by Excel/Office, not the
OS.

NickHK

 

[Harimau]

Ah, I see. Is that also the same reason why the default area for coding is
different? Like, when I use 2003 and double click on any objects that I make,
it takes me to the Sheet area and uses Private Sub, while on Mac I need to
link it to a Macro and it uses just Sub. Is there any particular difference
or disadvantage?

I've noticed the Forms control as well, and they seem to have mostly the
same features. However, there doesn't appear to be something equivalent or
similar to a Text Box in order to input data or output results. Or am I
missing something? What feature would you suggest for those purposes?

Thank you!

Iwan

 

[JE McGimpsey]

Forms Controls usually are attached to macros in regular code modules
rather than worksheet class modules.

You can read from and write to Textboxes from the Drawing toolbar, but
of course, they don't have the type of activeX events that Controls
Toolbox textboxes do.