A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Macros for Beginners



 
 
Thread Tools Display Modes
  #1  
Old August 18th, 2004, 08:35 PM
RTP
external usenet poster
 
Posts: n/a
Default Macros for Beginners

We have a Proposal Excel spreadsheet that I need to make some changes to. The
changes are quite complex and I believe will result in creating macros. I
have a programming background but am new to Excel Macros. Can anyone tell me
where I can go to reference Excel Macros and learn about them or suggest a
book, website, etc.. Maybe there is a website that has some real good
examples of the capabilities of Excel and macros and I can look at what's
happening in those samples and apply something similar to what I need to do.

For instance, I know I need to develop the capability to ask a Yes or No
question and go to a portion of that Excel spreadsheet that would be based on
the Yes or No answer to get additional proposal, spec information. (Sounds
like adding "Form" capabilities.)

Any suggestions would be GREATLY appreciated!!!

Thanks!
  #2  
Old August 18th, 2004, 08:48 PM
Bob Umlas Excel MVP
external usenet poster
 
Posts: n/a
Default

I am teaching a Master Excel class starting October 5.
It's both Excel & VBA.
It is done online from your home/office computer 12
Tuesday evenings (6-9PM est)
For details, visit:

http://www.iil.com/str_link_all_results.asp?
select_cartid=395&ld=VC0604



-----Original Message-----
We have a Proposal Excel spreadsheet that I need to make

some changes to. The
changes are quite complex and I believe will result in

creating macros. I
have a programming background but am new to Excel Macros.

Can anyone tell me
where I can go to reference Excel Macros and learn about

them or suggest a
book, website, etc.. Maybe there is a website that has

some real good
examples of the capabilities of Excel and macros and I

can look at what's
happening in those samples and apply something similar to

what I need to do.

For instance, I know I need to develop the capability to

ask a Yes or No
question and go to a portion of that Excel spreadsheet

that would be based on
the Yes or No answer to get additional proposal, spec

information. (Sounds
like adding "Form" capabilities.)

Any suggestions would be GREATLY appreciated!!!

Thanks!
.

  #3  
Old August 18th, 2004, 09:08 PM
Frank Stone
external usenet poster
 
Posts: n/a
Default

Hi,
See http://j-walk.com/
He has seveal books available.
-----Original Message-----
We have a Proposal Excel spreadsheet that I need to make

some changes to. The
changes are quite complex and I believe will result in

creating macros. I
have a programming background but am new to Excel Macros.

Can anyone tell me
where I can go to reference Excel Macros and learn about

them or suggest a
book, website, etc.. Maybe there is a website that has

some real good
examples of the capabilities of Excel and macros and I

can look at what's
happening in those samples and apply something similar to

what I need to do.

For instance, I know I need to develop the capability to

ask a Yes or No
question and go to a portion of that Excel spreadsheet

that would be based on
the Yes or No answer to get additional proposal, spec

information. (Sounds
like adding "Form" capabilities.)

Any suggestions would be GREATLY appreciated!!!

Thanks!
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using macros on custom toolbars in templates. Conan Kelly Worksheet Functions 2 August 2nd, 2004 02:28 PM
Custom Buttons linked to Macros surveyorinva General Discussion 1 June 16th, 2004 06:37 PM
macros don't work when workbook saved under new name Frank Kabel Worksheet Functions 0 June 9th, 2004 10:54 PM
Excel sees macros which are not there. Terry Setting up and Configuration 5 April 7th, 2004 02:14 AM
How to avoid the file that conatain macros Nikos Yannacopoulos Worksheet Functions 0 March 22nd, 2004 03:11 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.