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

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

"Nandezx" wrote in message
...
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

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

"NickHK" wrote:

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

"Nandezx" wrote in message
...
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