Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Greedo
  • Content: Threads
  • Order by date
  1. Greedo

    Password Protection

    I have an Excel macro that I programmed in Visual Basic. I would like to keep it so people that have the macro can't go digging around in my code. Does anyone know how to put this sort of password protection on? Thanks.
  2. Greedo

    Macro to Add In?

    I have a finished macro but am now interested in making it an add in. Does anyone know how to do this?
  3. Greedo

    VB Macro with more than one output

    I have made a VB macro that has more than one output but I am having trouble getting the two outputs into the correct cells. I have one cell whose formula is =Function(A, B). That one works fine but the Function also needs to put data into a cell that is two cells to the right (ie, Function is...
  4. Greedo

    VB Macro with more than one output

    I have made a VB macro that has more than one output but I am having trouble getting the two outputs into the correct cells. I have one cell whose formula is =Function(A, B). That one works fine but the Function also needs to put data into a cell that is two cells to the right (ie, Function is...
  5. Greedo

    For-Next not going to completion

    I have a for next loop that is supposed to go from 1 to 4 but stops at 1.5. If anyone can see anything wrong I would appreciate hearing about it. Dim varOne(4) As Single Static A(4, 8) As Double Dim Total As Double Static varTwo(4, 8) As Double Dim Max As Double For D = 1 To 4 Step 1...
  6. Greedo

    Excel to VB

    I posted this before and I got some help but I think I wasn't really clear enough about the problem. I am trying to get about 6 cells worth of data from one sheet in excel, about 4 cells worth from another sheet, do some simple calculations with those numbers, and then put the results into a...
  7. Greedo

    Excel to VB

    I posted this before and I got some help but I think I wasn't really clear enough about the problem. I am trying to get about 6 cells worth of data from one sheet in excel, about 4 cells worth from another sheet, do some simple calculations with those numbers, and then put the results into a...
  8. Greedo

    Getting Data from Excel to VB

    I am trying to get data from a spreadsheet into a VB file for a macro. There aren`t any manuals here in English so although I`m sure this is an easy question I have no way of looking it up. Anyway, I think I can do this using automation. I only need to get about 10 cells worth of data into the...

Part and Inventory Search

Back
Top