LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA on Excel 2004 Mac

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Merge Excel Mac 2004 Gene Augustin Excel Discussion (Misc queries) 1 March 8th 09 06:27 PM
Excel for Mac 2004 John New Users to Excel 1 September 30th 06 12:39 AM
What version of Excel comes with Office 2004 for Mac? jetsonsally Excel Discussion (Misc queries) 2 May 9th 06 03:43 PM
I can't format 01/19/2004 to read January 19, 2004, please help!! paulonline66 Excel Discussion (Misc queries) 5 June 17th 05 04:54 AM
Save as PDF Using VBA - Excel 2004 Mac rgarber50 Excel Programming 0 July 4th 04 07:38 AM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"