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

  • Users: Tuff
  • Order by date
  1. Tuff

    Data entry box

    Sorry should be more specific. I was wondering how the data entry box was created & linked to the actual spreadsheet?
  2. Tuff

    Data entry box

    Hi all, I recently found an old excel spreadsheet which contained a button which when pressed opened a data entry box. This data entry box looks like a standard windows box. (ie look and feel was similar to say windows volume control). The required data entry was for the key variables in the...
  3. Tuff

    Calculating number of Years

    Thanks everyone, What I have ended up using is to worksheet functions in conjuction with one another. =(DATEDIF(firstyear cell address,secondyear cell address + 1,"Y"))+((DATEDIF(firstyear cell address,secondyear cell address + 1,"YD"))/365). As the date range is not always an even year.
  4. Tuff

    Calculating number of Years

    Hi Guys, Is there a function or formula I can use in Excel to calculate the number of years between two dates. IE Start Date = 01/01/99 End Date = 31/12/04. I need the formula to tell me that is 5 years. (I am having a problem with the leap years).
  5. Tuff

    Linking macro to cell value

    Yep that did the trick. Thanks
  6. Tuff

    Linking macro to cell value

    Hi guys, I am sure it is possible to do this but I don't know how. I want to link a cell value to the macro. EG - Something like this. ActiveSheet.Select"Book2" Range("M13").Select ActiveCell.FormulaR1C1 = "Sheet"book1""C6" How can I go about...
  7. Tuff

    Macro with formula???

    Thanks heaps guys. Much appreciated.
  8. Tuff

    Macro with formula???

    Hi Guys, Just wondering if it is possible to link a macro to a cell value within a spreasheet. ie change the following: "\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\M03105.xls" To say something like this...
  9. Tuff

    Selecting a Range

    Thanks guys all excellent suggestions. But I think I will used to the ActiveCell.End(x1Down).Select option. If you can't work smart, then you should just work hard.
  10. Tuff

    Selecting a Range

    Morning/afternoon everyone, I am writing a macro that needs to highlight and copy a range of data. However the amount of rows used varies everytime it is run, and I don't know how to get it to just highlight the data that is there. Similar to this except in the downward direction...
  11. Tuff

    Protecting a worksheet

    Thnks Geoff, Seems to be working well.
  12. Tuff

    Protecting a worksheet

    Is is possible to protect a worksheet in a way where it prevents a user from using the CUT & PASTE function. And if does this also apply to the COPY & PASTE function. Thanks
  13. Tuff

    How do I?

    Ok got a bit of tricky on here. I have written a macro in excel, and it creates a sheet alters the data in it, and then delete the sheet. However when I run the macro it always comes up with the message box asking. The Selected sheet will be permantely deleted. To Delete the selected sheets...
  14. Tuff

    Using Find Function in VB

    Thanking you. Worked perfectly
  15. Tuff

    Using Find Function in VB

    Hi Guys I am stuck. I am using the find function to get a cell reference in an excel spreadsheet, but then I need to move up one cell (as it is the cell above the one it finds that I want to delete). I can get it go to the cell that I want it to find, but then I can get it to move one cell...
  16. Tuff

    How to move cursor

    Hi everyone, How do I get my cursor to move up or down cells in Excel. I don't want to move to an exact cell reference point. I want it to find a certain value within the spreadsheet, then move either up or down one cell. Can I do this? Thanks
  17. Tuff

    Cell Referencing

    Thanks Andrew, That worked a treat. I came up with a similar idea, but I didn't know how to put that in VB code. Much appreciated.
  18. Tuff

    Cell Referencing

    When writing a macro is it possible to use the find function to set your cell reference. IE. To find the cells that need to be selected, I need to use the find function, as the cell position I need changes from G23 to G35 to G189 etc etc everytime. Once I find the cell I simply need to select...
  19. Tuff

    use foxpro 2.6 with ADO

    J would like to know the solution to use foxpro 2.6 with Active Data Object, because j can't open my database with ADO, j have tried to use Dbase driver but j have no success. thanks for your help. Rico

Part and Inventory Search

Back
Top