Hello, I don't know anything about VBA, but I did manage to record my first few helpful macros. But I would very much like to learn how to have a macro run automatically once a certain cell is filled in. How can I do this?
Hello, I don't know anything about VBA, but I did manage to record my first few helpful macros. But I would very much like to learn how to have a macro run automatically once a certain cell is filled in. How can I do this?
Last edited by thejayjetson; 06-22-2012 at 03:46 PM. Reason: left out word
Hi,
I like your idea.
You can say something like....if the activecell has content in it, then invoke a macro.
I think this is totally possible. But if you have a dummy workbook you can post, it would be helpful.
Lifeseeker
IClaim.xlsm
Thanks for the awesomely quick reply.
I want to learn how to run any macro automatically when whatever cell i designate is filled in. But for my first learning purposes, if B3 is filled in then I want to have my ctrl+t macro run automatically.
Last edited by thejayjetson; 06-22-2012 at 04:03 PM. Reason: Upload was correct-no need to ask
try this solution
Well, that obviously works. Bravo. But how in the heck did you possible do this? I really want to learn.
just press All+f111 and open sheet1 module to look at the code
I see:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Row = 3 And Target.Cells.Column = 2 Then
Call Dateandtime
End If
End Sub
But how did you input this?
manually, you can not write macro like this just hitting button - record macro
How do you manually do it? I don't just want the work done for me. I want to learn what you did to make it work.
What about you Lifeseeker, do you where to put the code I copied from Power?
Come on. There must be someone here that knows how to do this???????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks