Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Can I call an Excel macro from cell
Name: Mark Selden Date: December 13, 2002 at 00:16:56 Pacific OS: xp CPU/Ram: 1.6/256
Comment:
Hello: Is it possible to execute an excel macro based on condition of a cell?
Name: A Certain TH Date: December 13, 2002 at 04:59:27 Pacific
Reply:
Yes. There are two ways to do it (that I can think of)
-you have an ongoing macro which automatically runs every second which checks the cells and executes your desired macro if a condition is met -you have a routine which executes every time a change is made to the sheet which checks every cell, such as the following example: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Cells(1, 1) = "Hi" Then RunMeNow End Sub Sub RunMeNow() MsgBox ("Hello to you too!") End Sub
Right click on the name tab of a worksheet, select "View Code" and paste in that text. Do whatever you want on the sheet, and as soon as you enter the word "Hi" into cell A1, then the macro RunMeNow executes.
Summary: Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down menu which you can use to select an option from. Wh...
Summary: hello, i have an excel spreadsheet on which in column D i have dropdown validation list with Yes/No in it. i need a macro that will check to see which dropdown has been changed for example say i have ...
Summary: Hello, I'am trying to create files from a table. All I'm able to do so far is create files by manually selecting the cell I want. How can I have it create them from an entire range of cells? This is t...