User Profile

Collapse

Profile Sidebar

Collapse
mitsy
mitsy
Last Activity: Oct 5 '07, 04:57 AM
Joined: Sep 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mitsy
    replied to How to exit a While loop
    in Visual Basic
    Ahhhhhhhhhh!!!! !!!!!!!!!!!!!!! !!! Nope nothing nothing nothing! Tried everything! NOTHING WORKS! Have I mentioned how much I hate VBA? Sorry if I offended you programers out there!
    See more | Go to post
    Last edited by Killer42; Oct 5 '07, 06:46 AM.

      Leave a comment:

    • mitsy
      replied to How to exit a While loop
      in Visual Basic
      exit sub doesn work either :'(...
      See more | Go to post

        Leave a comment:

      • mitsy
        replied to How to exit a While loop
        in Visual Basic
        i want to end the method. STOP the WHILE statement!...
        See more | Go to post

          Leave a comment:

        • mitsy
          started a topic How to exit a While loop
          in Visual Basic

          How to exit a While loop

          i have to use something to END a program. how ever using end isnt workin!

          Code:
          While ActiveSheet.Cells(Row, COL_DATA) > 0

      ActiveSheet.Cells(ROW_NUMDISKS, COL_DATA) = InitialRadiusValue + NewRadiusValue
      InitialRadiusValue = InitialRadiusValue + NewRadiusValue
      Row = Row + 1
      
        If ActiveSheet.Cells(Row, COL_DATA) < 0 Then
           ActiveSheet.Cells(ROW_NUMDISKS,
          ...
          See more | Go to post
          • mitsy
            replied to Making Boxes
            in Visual Basic
            no oneeeeeeeeee??? :(
            See more | Go to post

              Leave a comment:

            • mitsy
              started a topic Making Boxes
              in Visual Basic

              Making Boxes

              hello0o im using Ms Excel Vba (2003) editor and im trying to generate a box to keep disks! im going to put numbers in excel, which VBA is gonna count as radius of disks hence number of disks (have done that bit) now depending on the radius i want to generate a box! now i kno the height of the box is 2*the max radius value...but im havin problem trying to generate an algorithm for the width. so can any one plzzzzzzzzzzzzz zzzzzzzzzzzzzzz help me?...
              See more | Go to post
              • mitsy
                replied to Counting - Ms Excel
                in Visual Basic
                thank you i tried to do it in a different way! now its working! thanks anyway:)...
                See more | Go to post

                  Leave a comment:

                • mitsy
                  replied to Counting - Ms Excel
                  in Visual Basic
                  I'm using VBA built in Excel 2003.
                  I'm not sure I understand what you mean by "the actual code" because I don't really have any code yet... I'm trying to make a code to make Excel count the number of values I put in a certain column... do you know what I'm saying? Hope that helps! Coz I need yours!...
                  See more | Go to post

                    Leave a comment:

                  • mitsy
                    started a topic Counting - Ms Excel
                    in Visual Basic

                    Counting - Ms Excel

                    Hello. I have been trying to do this for a LONG time but not getting anywhere so I was wondering if anyone could help me out.

                    This is the problem. I'm gonna out sum values (radius of disks) in Excel, and I want VB to count how many values (disks) I have put. I have to use a While statement and this is what i have done (wrongly) so far...
                    Help anyone??

                    [CODE=vb]DimRadiusOFDisk As Integer

                    Initial...
                    See more | Go to post
                    Last edited by Killer42; Sep 28 '07, 02:41 AM. Reason: Added CODE=vb tag
                    No activity results to display
                    Show More
                    Working...