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!

  • Congratulations bkrike 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: LBryant777
  • Content: Threads
  • Order by date
  1. LBryant777

    Search on array index

    I had a directive to create an array, find the largest value, then find the index number of the largest value in the array. I have most of it written, but I'm stuck calcualaing and showing the index. Here is the code so far: #include <iostream> #include <cmath> #include <iomanip> using...
  2. LBryant777

    Force mandatory input into cell

    I am working on a workbook and I want to use an checkbox control to be checked off on each sheet when the worksheet is completed. However, there is one merged cell (d15 -k15) on each sheet that needs to be filled in with text before the sheet can be considered complete. I tried using this code...
  3. LBryant777

    Force mandatory input into cell before closing

    I am working on a workbook and I want to use an checkbox control to be checked off on each sheet if the form is completed. However, there is one cell on each sheet that needs to be filled in with text before the sheet can be considered complete. I tried using this code attached to an ActiveX...
  4. LBryant777

    Learning how to use ActionListener

    Here I am again: This time, I am attempting to create a smiley face (done) with a button that will change the smile from a frown (my problem). I believe I'm almost there, but I'm missing something that is probably relatively simple... My code: import java.applet.*; import java.awt.*; import...
  5. LBryant777

    Conditional Formatting Code in Macros

    I submitted a question pertaining to conditional formatting that was answered in this thread: thread68-819125. When I do this manually, it works like charm. However, when I try to incorporate this method into an existing macro, it does nothing. Here is the code it is a part of (inserted code in...
  6. LBryant777

    Retaining private views after server refresh

    I created several private views from a Notes db so that I can update a daily report by just glancing at a view and not opening every record. Every couple of months, Notes Admin does a db refresh and my private views disappear with the old version of the db. Isn't there a way to keep my private...
  7. LBryant777

    Advanced Conditional Formatting in Excel?

    I produce a daily timeline report that reads from dates and times from another worksheet in the report. The formula that I use to create my ‘timebar’ =IF(AND(E$1>=($C2-TIME(0,0,1)),E$1<=ROUND($D2*24/0.25,0)*(0.25/24)),"P","") Row 1 holds the value for each hour of the days I am currently...
  8. LBryant777

    Excel 2000 Macro conversion to Excel 97

    I created two macros in Excel 2000 that hides and unhides rows that do not have shading in them and they are assigned to a toggle button. However, when the same macro is executed in Excel 97, users get a Runtime 1004 error that says "Unable to set the Hidden property of the Range class." Here is...
  9. LBryant777

    Trying to separate class into multiple classes

    I started this out as one class, but I need to separate it out into different classes with constructors, getters and setters. I've gotten this far and now I'm lost. Plus now I get an error: java.lang.Error: Unresolved compilation problem: Syntax error on token "principal", ".", "[" expected...
  10. LBryant777

    Advanced Conditional Formatting in Excel

    I produce a daily timeline report that reads from dates and times from another worksheet in the report. The formula that I use to create my ‘timebar’ =IF(AND(E$1>=($C2-TIME(0,0,1)),E$1<=ROUND($D2*24/0.25,0)*(0.25/24)),"P","") Row 1 holds the value for each hour of the days I am currently...

Part and Inventory Search

Back
Top