LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
BDP BDP is offline
external usenet poster
 
Posts: 3
Default Excel VBA UserForms in in Mac OS X

I've created an Excel workbook with several userforms and macros, and need it
to run on a Mac running Excel X. When I open the workbook in Excel X on the
Mac, and open the VBA Editor, none of my forms show up - as if the VBA
project contained no userforms at all - and executing the code to load and
show the forms causes an error.

I've read that the Mac version of Excel doesn't support ActiveX controls.
My question is: is there a way to build a userform in Excel VBA (in Windows)
using controls that aren't ActiveX controls? Or is ActiveX all there is for
building userforms in Excel VBA? I've seen people say to use the controls
from the Forms toolbar in Excel, but I don't want to add controls to the
workbook, I want to add them to a userform (if this makes any sense).

Thanks
 
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
Excel and launching userforms Lumpjaw New Users to Excel 6 August 21st 06 01:39 AM
Closing excel userforms Jim[_57_] Excel Programming 4 June 15th 05 05:27 AM
Help Userforms / Excel SUMIF Hopest Excel Worksheet Functions 4 June 3rd 05 05:38 PM
Creating UserForms in Excel RayzGurl Excel Programming 1 February 1st 04 11:55 AM
How to load userforms in excel (vb) zisko3 Excel Programming 1 January 29th 04 02:28 AM


All times are GMT +1. The time now is 05:40 PM.

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"