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 strongm 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: *

  1. futbuk

    Look up matching values and return value to cell

    Sheet 1 has 2 columns (A & B) -A column is a description and B column is the cost of the the item being described Ex. Sheet 1 Column A Column B Tool $2.00 Desk $200.00 Chair $50.00 Sheet 2 has the same 2 column headings as Sheet 1 and Column A has the same descriptions as...
  2. futbuk

    Activating (or calling on) a Form

    I currently have an excel worksheet set up to call on a calendar form everytime the user clicks cell B2 as follows: This code is in the "ThisWorkbook" Private Sub Workbook_Open() Sheets("INPUT").OnDoubleClick = "Input_Form" End Sub This is the module Sub Input_Form() Dim...
  3. futbuk

    Keeping text boxes aligned to data points on a chart

    I have a standard chart (Dates across bottom data above).Every now and then I add comment boxes with arrows pointing to a specific data point on the chart. Each day when I enter new data to the chart my text boxes (and arrows) get misaligned (due to the addition of new data). Does anyone know of...
  4. futbuk

    Excel Unable to Read File

    Thanks Ken, I tried the detect and repair in Office 2003. I lost all my formats and graphs. All the data was there but.... It'll take a long time to replace everything. As for backups, I'm still waiting for the I.S. guys to restore a backup. Like to rely on that but I'm going to try your...
  5. futbuk

    Excel Unable to Read File

    Trying to open an excel 2000 file that has been working properly for over 2 years and suddenly it comes back telling me: "Unable to read file". I have no idea why this has occured nor can I correct it. Any suggestions?
  6. futbuk

    gridlines won't print

    You may need to reinstall your printer driver. I have had this problem on occasion when I receive excel graphs/data from overseas (japanese) and I don't have the correct driver to read their character sets. Sounds like a driver problem to me.
  7. futbuk

    Excel Vba problem

    Instead of inserting a line at row 7 every time and inserting a data entry, I really wanted this macro to begin recording the data from line 7 downward so that the newest data entry appears on the bottom line instead of the top. Any suggestions? Application.ScreenUpdating = False...
  8. futbuk

    Almost works

    thanks Red lol, 1 of these days I'll learn to read
  9. futbuk

    Almost works

    Instead of inserting a line at row 7 every time and inserting a data entry, I really wanted this macro to begin recording the data from line 7 downward so that the newest data entry appears on the bottom line instead of the top. Any suggestions? Application.ScreenUpdating = False...
  10. futbuk

    VBa Printing Problems

    figured it out, doh!
  11. futbuk

    VBa Printing Problems

    Trying to create a macro to format a sheet to fit on 1 to 2 pages (this varies) and present itself in the print preview ready for printing. The file I'm using this macro for recieves updates via a link which adds a new data entry to the bottom row each time it gets updated (that is of course if...
  12. futbuk

    Windows Update not working

    Are you using a burnt copy of XP........If so I believe that may be your problem

Part and Inventory Search

Back
Top