Phelony
07-09-2009, 06:05 AM
Hi Guys
If from the title you happen to know the answer is "you can't", then don't worry about anything else here.
If however, that's not the case, then I have a problem! :help
I've got a macro that runs from a command button, it picks up one of several input factors in a given cell and then runs off to find the appropriate data.
However, in testing, it turns out that people aren't quite getting the whole "press return" concept. So, I've thrown in a little message box code to tell them what to do if they haven't committed the data entry into that cell.
If Range("E2") = "" Then
MsgBox ("You must enter a valid code or account number and press enter for the search function to work")
Else
End If
Thing is, this isn't working. :motz2:
Is this because you simply can't run a macro whilst editing? Or is there a way to do it that would mean an improvement to the code I've got?
Silly question most likely as I susepect it's the prior of the two, although it never hurts to check! :think:
Thanks
Phel x
If from the title you happen to know the answer is "you can't", then don't worry about anything else here.
If however, that's not the case, then I have a problem! :help
I've got a macro that runs from a command button, it picks up one of several input factors in a given cell and then runs off to find the appropriate data.
However, in testing, it turns out that people aren't quite getting the whole "press return" concept. So, I've thrown in a little message box code to tell them what to do if they haven't committed the data entry into that cell.
If Range("E2") = "" Then
MsgBox ("You must enter a valid code or account number and press enter for the search function to work")
Else
End If
Thing is, this isn't working. :motz2:
Is this because you simply can't run a macro whilst editing? Or is there a way to do it that would mean an improvement to the code I've got?
Silly question most likely as I susepect it's the prior of the two, although it never hurts to check! :think:
Thanks
Phel x