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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |