Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 97 Support Sites?

18 views
Skip to first unread message

Wayde Bendus

unread,
Oct 14, 1998, 3:00:00 AM10/14/98
to
Can somebody please provide me with some web sites that focus on
illustrating, demonstrating and exampling tips and tricks for using Excel97
and specifically Excel97 and VBA?

--

Sincerely,

Wayde D. Bendus
-----------------------------------------
E-mail: wbe...@stny.lrun.com
URL: http://home.stny.lrun.com/waydebendus


Jim Youngman

unread,
Oct 14, 1998, 3:00:00 AM10/14/98
to Wayde Bendus
http://www.j-walk.com/ss/excel/ is a good place to start.

--
==================================================
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
==================================================

vcard.vcf

Ogilvy, Thomas, W., Mr., ODCSLOG

unread,
Oct 14, 1998, 3:00:00 AM10/14/98
to
http://support.microsoft.com/support/downloads/dp2638.asp
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

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

http://www.BMSLtd.co.uk

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?

0 new messages