Excel + VBA: Creating a macro that can be applied to any cell.?
957844
That's easy, connect the two together by 1st the title of the worksheet along with the subtitle, then along with the label name and finally the location; all in one line.
668871
You may have to write that fomula out manually. \n \n=OR(AND(A1,NOT(B1)), AND(NOT(A1),B1))
142557
you would need a compiler.. I assume your writing a visual basic program..\nThe easiest to do it is to use EXCEL assuming you have excel... You have to look in the macro area in tools bar. There is a visual basic editor!\n\nBut if your planning to program a program*, you can use Microsoft Visual Studio to do so... It costs money thou! GEt an educational copy (free).\n\nThe excel way is free... if you have office excel..
521317
Doing this is a little tedious but can be done. The tedious part is the first part.\n\n1- Let's assume that each sheet has a name with no spaces (i.e. sheet1, sheet2, etc) AND each of the 134 sheets has the same number of rows and columns. Copy the data area from sheet1 into a new sheet and 'paste link'. You'll have to do a find/replace and change each column letter to have a $ before it (i.e. d to $d$). Add the second $ to take care of the rows at the same time.\n\nCopy the data area in this new sheet under itself so now you have two identical sets. Do the same copy paste under operation 134 times (or until you run out of rows).\n\nOnce you have this done, you are going to have to do 133 find/replace operations and you are searching for sheet1 and replacing with the next sheet. Make sure you highlight the areas of interest. For example, on your second find/replace, highlight all the data under the first section. On your third, select all areas under the thinrd section. That way you aren't replacing the stuff you already did. example, your first set ends at row 100. Highlight row 101 to row 65,536, replace sheet1 with sheet2. Third set, also 100 rows. Highlight row 201 to 65,536 find/replace sheet2 with sheet3, etc.\n\nTedious & time consuming but if you aren't willing or don't know how to code in VBA, the easiest way to do it.
1059707
As much as I know about Excel, I have never seen the ability to do that. Your best bet would be to Merge multiple Cells in 25-50. This is about the only way to get the desired effect but it isn't exactly what you want to do I am guessing.
566782
We can do it with short cut keys, copy can be done with control C and pasting can be done with Control V. But before copying u shall hv to select it, that can be done with shift arrow. If u know the visual basic editor, u can make a short cut key of macro also. Now there r two alternatives and choice is urs.
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
79970
right click on cell, select format cell.
817800
Here's some instruction for a UDF (User Defined Function) to do what you need.\n\nhttp://www.ozgrid.com/VBA/HyperlinkAddress.htm
882322
I would start by playing around with the macro recorder.   Goto Tools-Macro-Record New Macro.\n\nPerform a few tasks and then click the stop button.  \n\nNext try to run the macro, by going to Tools-Macros and selecting Macro1.  \n\nNext go into Tools-Macro-Visual Basic Editor.  Click on your workbook and then click on Module 1.  You should see the code for the macro you just recorded.  You can try fiddling around changing a couple variables etc.  \n\nYou can do a great deal of things by just recording and editing.  Ultimately, you should buy a book on VBA (the programming language Excel uses for macros) if you want to do anything complicated.\n\nBTW the previous answer was mistaken.  Formulas and macros are two entirely separate things and macros definitely do exist in Excel.
137598
Might help if you can explain what it is you're doing a little.  But, I'd just use the Ctrl+F and type in the keyword and search that way.  Also, you may try researching assistive devices and software used by blind or other disabled peoples that has the ability to 'read' text.  Or find someone to write a macro that uses Ctrl+F and calls and runs a .wav file when it returns a positive hit and then make the program loop after the refresh program runs (it would execute itself automatically after each time a page refreshes).  Hmmm... I'm not a great programmer (it takes me a really long time and I usually just use VBScript).  Sorry I can't give you code, but the idea there is sound.
709713
You can simply use an "IF" statement.\n \nLet's say in A column some cells have values & some don't - for the one that has a value (non-blank), you'd like put the number "2" next to it (in the B column), here the formula -\n\n=IF(A1<>="",2,"")\nThis means if A1 is not blank, then put 2 in B1, otherwise leave it blank.
744410
I use a macro program called Workspace Macro. I recommend Pro version. For $15 more you can get hotkeys and ability to edit macros. You can get more information from http://www.tethyssolutions.com/macro-automation.htm
1058270
A macro is a procedure written in Microsoft's Visual Basic For Applications (VBA).  You can 'record' a new macro to perform repetitive tasks without having to know programming code.\n\nFrom Microsoft's Support:\n\n"Write a macro\n\nIn the Office programs in which you can record macros, as well as in Access, Outlook, FrontPage, and Publisher, you can write your own VBA macros. To write a macro, you do need to know a bit about VBA, but you might be surprised at how easy it is to pick up because of what you already know just by using the program. VBA is all about automating the features you use every day. For example, in Word, VBA terms include such things as documents, tables, paragraphs, or sections. \n\nWriting a macro, or editing a macro that you have recorded, gives you the ability to add more power to your macros. For instance, with the macro recording example above, you could edit that recorded macro by adding what is called a loop—simple VBA code that can enable the macro to apply the formatting to all tables in your document at once, rather than you having to run the macro separately for each table.\n\nOne of the best things about writing or editing VBA macros is that once you know how to write just a little bit of VBA in one Office program, you can use much of that knowledge to write or edit macros in the other Office programs. Terminology differs for specific features, but the language you need to know to set up a macro, or add features such as loops, is identical for any program that uses VBA. \n\nTip: A good way to begin learning VBA is to record a macro and then look at the macro in the Visual Basic Editor. To do this, on the Tools menu click Macro, and then click Macros. Select your recorded macro from the Macro name list and then click Edit."
1075938
This macro will create a random number that does not change, even when the sheet is recalculated. It prompts you for an upper limit, a lower limit and then for (integer or decimal).\n\nSub RandomNumber()\nupperLimit = InputBox("Enter Upper Limit")\nlowerLimit = InputBox("Enter Lower Limit")\nnudp = InputBox("Just hit OK for Integers or type D for decimals")\nIf UCase(nudp) = "D" Then\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0.0000"\n   End With\n   For Each cell In Selection\n       cell.Value = Rnd() * (upperLimit - lowerLimit) + lowerLimit\n   Next cell\nElse\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0"\n   End With\n   For Each cell In Selection\n       cell.Value = Int(Rnd() * (upperLimit - lowerLimit + 1) + lowerLimit)\n   Next cell\nEnd If\nEnd Sub
270211
Methods or events?  There are any number of "methods" a button could perform, all the way up to "close program" I think, but only a couple of events it can respond to.  \n\nPossibly "mouse click", "mouse over", and "mouse out" are three of these.\n\nTry a Yahoo search on "VBA Excel tutorial" for more help.
586461
I thought the istext formula would work but they don't.\nHere's another way to solve this issue. Assume the cell to test is in A1, enter the following formula in another cell:\n\n=IF(ISERROR(LEFT(A1,1)/1) ,"yes","no")