Talk:Excel VBA

Hello World
Great idea - however - you jump right in without giving newcomers any context. A new section needs to be added at the top, telling us exactly what buttons to press and options to choose to get our first program running. A "Hello World" example, in other words :-)

Recipes Wanted
Good start. Of course the information I want isn't there :-) Would it be worthwhile adding a list of recipes wanted here?  Well I'll add one anyway; formatted as a definition list.  Anyone who has a better idea is, of course, free to fix it.  --kwhitefoot 10:08, 26 September 2005 (UTC)


 * Resize Range: I need a routine that will resize a range by inserting or deleting rows as necessary. I have a template sheet that includes named ranges. I need to resize them, moving all the rows that are below up or down as necessary. --kwhitefoot 10:08, 26 September 2005 (UTC)

Protect/unprotect; if certain cells un empty or null
---Excellent work!--- I need to protect certain cells depending on a condition. Input is allowed in either column G9,H9,I9,J9,K9 and rest all cell must be protect. For example if user has input in G9 column then H9,I9,J9,K9 must be protect; same is with rest columns. Any single column used for input. How can i achieve this task.

Comparing values in 2 columns in excel
I would like to write (or insert) a program what will sequentially compare a value in cell b1 to all cells in column A. I want this to repeat for the value in b2, and so on until all values in column B have been compared to all values in column A.  If a value in column b=value in column a, then I want the program to return a "1" in that row of column C. How do I do this?

LibreOffice
Suggest create a "translation" to the free suite LibreOffice. --Diamondland (discuss • contribs) 08:27, 12 June 2012 (UTC)

Breaking into subpages
I object to breaking this book into subpages. --Dan Polansky (discuss • contribs) 10:20, 23 June 2013 (UTC)

Book name
I have renamed the book from Microsoft Excel Programming Recipes to Excel VBA. The book was only about VBA; for C++, there were just two links and no other info. "Microsoft" is unneeded in the book name. "Recipes" was okay but not strictly needed; removing it makes the book title nicely short and focused. --Dan Polansky (discuss • contribs) 07:25, 13 July 2013 (UTC)