Windows 10: VBA Question

Hi all, I am attempting to teach myself VBA in Excel and I am asking is it possible to invoke a macro depending on the contents of a cell? please.
Len

:)

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

VBA Excel Question

I'm going through someone elses code in VBA Excel - how do I know that "FIELD 16" is?

ActiveSheet.Range("$D$2:$R$5000").AutoFilter Field:=16, Criteria1:="="

 

VBA on windows phones and tablets

I want to use Powerpoint to prototype an app that I am building. As such I need to customize the PPT file with VBA to do things like have countdown timers, drop down lists, popups etc.

From my research it appears I need a Surface Pro tablet with full office. Anything else like RT won't do the job.

However, I can't determine if a Windows phone will support VBA.

Can anyone confirm if full VBA support is available for Windows phones and tablets? And if so which OS and model.

Thank you,