Senin, 28 Maret 2016

Re: [ExcelVBA] excel vba

 

I have not replied because I still don't know what help you need.  

If you are trying to convert a spreadsheet which uses formulae into one which has buttons and these drive vba code, you need to say so.  

You also need to define the end product:-  

  • What data will you have and where will it be located?
  • What buttons will you have?  Where will they be located? What actions will they trigger?
  • What actions do you want the vba code to perform?
  • If the vba code is not triggered by the buttons, what is it triggered by?

Then you need to start writing the code.

If you have any problems with this give us the information about the end product you are trying to achieve, the code you have written, and what problem you need help with.




Regards
David Grugeon

On 21 March 2016 at 03:17, sf49ers164480@outlook.com [ExcelVBA] <ExcelVBA@yahoogroups.com> wrote:


SCORE B6:B22

=IF(C6="BYE","",IF(VLOOKUP($A$2,Inputscores,A6+1,FALSE)="","",VLOOKUP($A$2,Inputscores,A6+1,FALSE)))



OPPONENTS  SCORE D6:D22

=IF(C6="BYE","",IF(VLOOKUP(C6,Inputscores,A6+1,FALSE)="","",VLOOKUP(C6,Inputscores,A6+1,FALSE)))



OPPONENTS CONFERENCE E6:E22

=IF(C6="BYE","",VLOOKUP(C6,CONFERENCE,2,FALSE))

 

OPPONENTS DIVISION F6:F22

=IF(C6="BYE","",VLOOKUP(C6,CONFERENCE,3,FALSE))



cONFERENCE IS IS IN NAME MANAMENR, AS CONFERENCE


this is old one  my friend help made. now i making  new one do everything by vba codes


Meet Google Drive – One place for all your files

Meet Google Drive – One place for all your files
Google Drive is a free way to keep your files backed up and easy to reach from any phone, tablet, or computer. Start with 15GB of Google storage – free.
Preview by Yahoo





__._,_.___

Posted by: David Grugeon <grugeon@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar