Results 1 to 2 of 2

Thread: convertir code VBA to VB.NET

  1. #1
    Woo! Hoo! my 1st post
    Join Date
    2015-04
    Posts
    1
    Login to Give a bone
    0

    Default convertir code VBA to VB.NET

    Hi I have code in VBA i want to convert it to VB.NET
    the code
    Code:
    • Dim lastrow AsInteger
    • Dim curRow AsInteger
    • Dim newrow AsInteger
    • lastrow = exWS2.Cells.Rows.End(XlDirection.xlDown).Row
    • exWS2.Cells(8,6).Value ="Max"
    • exWS2.Cells(8,7).Value ="=Max(B2:B"& lastrow &")"
    • newrow =8
    • For curRow =2To lastrow
    • If exWS2.Cells(curRow,2)= exWS2.Cells(8,7).Value Then
    • newrow = newrow +1
    • exWS2.Cells(newrow,6).Value = exWS2.Cells(curRow,1).Value
    • EndIf
    • Next curRow

    help me

  2. #2
    Past Vice President / AUGI Volunteer peter's Avatar
    Join Date
    2000-09
    Location
    Honolulu Hawaii
    Posts
    1,029
    Login to Give a bone
    0

    Default Re: convertir code VBA to VB.NET

    VBa and VB.net have similar variable declarations.

    Is there some reason you would not like to do it in LISP?
    AutomateCAD

Similar Threads

  1. 2012: CONVERTIR POLILINEA DE RASANTE
    By jhonfre56 in forum Español - AutoCAD Civil 3D
    Replies: 3
    Last Post: 2017-07-03, 07:03 AM
  2. 2012: CONVERTIR POLILINEA DE RASANTE
    By jhonfre56 in forum Español - AutoCAD Civil 3D
    Replies: 0
    Last Post: 2013-10-16, 01:19 PM
  3. Convertir un Sol en Terre-Plein
    By Do.Payelleville in forum Revit Architecture - Liste de souhaits
    Replies: 7
    Last Post: 2012-02-24, 12:18 PM
  4. convertir fichiers 3ds en rvf ?
    By dume.susini in forum Revit Architecture - Familles
    Replies: 3
    Last Post: 2010-08-21, 02:05 AM
  5. convertir un fichier pdf
    By la-miche in forum Français - AutoCAD / AutoCAD LT - Général
    Replies: 2
    Last Post: 2009-07-24, 08:34 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •