--
Sincerely,
Wayde D. Bendus
-----------------------------------------
E-mail: wbe...@stny.lrun.com
URL: http://home.stny.lrun.com/waydebendus
--
==================================================
Jim Youngman, Senior Operations Analyst
RACV
550 Princes Highway Phone: +61 3 9790 2914
Noble Park VIC 3174 Fax: +61 3 9790 2777
Australia email: Jim_Yo...@racv.com.au
==================================================
This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms
This first Link should provide you most of what you want to know about
working with commandbars. It is about 40 pages I believe and has plenty
of sample code. As I recall, it specifically addresses replacing menus.
http://support.microsoft.com/support/downloads/dp2586.asp
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for
writing Visual Basic(R) for Applications code to customize menus in
Microsoft Excel 97. This Application Note contains code examples that
you can use with the following elements: menu bars, menus, menu items,
submenus, and shortcut menus.
http://support.microsoft.com/support/downloads/dp1510.asp
While dialogboxes have been replace by userforms, they are still
available, and the Forms Controls are probably easier to use on the
worksheet:
File Title: Sample Visual Basic(R) Code for Controlling Dialog Boxes in
Microsoft(R) Excel 5.0 and 7.0 for Windows(R)
File Name: WE1162.EXE
File Size: 82026 bytes
File Date: 07/08/96
Keywords: appnote vb macro we1162 dialogs
Description: This Application Note will help you learn some techniques
for writing Visual Basic, Applications Edition, code for controlling
dialog boxes. The file includes sample code.
Microsoft Office Developer sites:
http://www.microsoft.com/officedev
http://www.microsoft.com/exceldev
http://support.microsoft.com/support/excel/default.asp
Go down the programming item for some special topics.
John Walkenbach
http://www.j-walk.com/ss/excel
Chip Pearson
http://home.gvi.net/~cpearson/excel.htm
Stephen Bullen is a good code site
And the Baarns site has code also:
http://www.baarns.com although I think theirs is more towards 97. I
haven't spend much time there, actually (just haven't had a chance).
This site has some good info:
Go to
http://support.microsoft.com/support/c.asp
In step 1 select Excel for Windows
In sept 2 select the first button (Keywords)
In step 3 enter these criteria pgmHowTo
In other options select fulltext for the first
Your choice on the second. I usually just go for titles.
That should give you 100 or more articles on how to do a variety of
things.
HTH,
Regards,
Tom Ogilvy
> ----------
> From: Wayde Bendus[SMTP:wbe...@stny.lrun.com]
> Posted At: Wednesday, October 14, 1998 12:18 AM
> Posted To: microsoft.public.excel.programming
> Conversation: Excel 97 Support Sites?
> Subject: Excel 97 Support Sites?