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 SkipVought 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. quicklearner

    Does a Formula exist?

    Ken, I do believe Zathras is the closest to my desired goal.[thumbsup2] I had used Autofilter a year ago on a different project but somehow forgot how to set it up.[surprise] I did try the MS Query, which I think would also work, but I'm having trouble with setting it up. I'm being told that...
  2. quicklearner

    Does a Formula exist?

    Okay guys I am going to review your answers and determine which one fits the bill for my needs. I need to keep costs down for my client, so naturally the easiest course will be my choice. I'll let you know in a few days what works.:-> To answer Ken Wright's question: 1. "Are they all on a...
  3. quicklearner

    Does a Formula exist?

    I have used excel to create a legal document matrix. The columns are labeled to separate and identify dates, attorneys, abbreviated motion language and complete motion language. The rows will be identified with a tab number to correspond to how/where the document is filed. Due to the number of...
  4. quicklearner

    Need Help with Date/Time Function

    Thank you to zathras for a perfect answer. That macro does exactly what I needed!
  5. quicklearner

    Need Help with Date/Time Function

    I tried your formulas, and the last column enters the date and time as a decimal. I am not at all familiar with macros. Isn't there an easier solution? All I need is when an entry is made in column A, a non-changing date and time stamp occurs in column B. A solution can't be that hard?
  6. quicklearner

    Need Help with Date/Time Function

    Could you please explain this formula alittle bit? Would I be adding another formula to this one based upon how I format the Date/Time? I need for the date and time to be stamped into the cell and not change once the event occurs. (I think I didn't clarify that in my earlier post)
  7. quicklearner

    Need Help with Date/Time Function

    For my workgroup I have created a log in excel. Column A is the "Person/Role", Column B is the "Date & Time" and Column C is for "Comments & Notations." I would like for everytime a person enters their name in the cell under Column A, that the current date and time...
  8. quicklearner

    Upon Opening Word: Visual Basic compile error in hidden module-WFMain

    Yes, I have attempted to rename normal.dot, without success. PC clean-up? I think I have cleaned what I can from this computer. The user is not very considerate and absolutely has NO CLUE when it comes to operating a computer the proper way. He downloads programs he's not supposed to, emails all...
  9. quicklearner

    Upon Opening Word: Visual Basic compile error in hidden module-WFMain

    I have determined that "WF" means "word fill" on the task bar of the Word program. Every feature in its pull down menu generates compile error, so my guess is this entire module is bad. Even the help menu doesn't come up for this one. This particular computer does have...
  10. quicklearner

    Upon Opening Word: Visual Basic compile error in hidden module-WFMain

    I am receiving the following error message when opening Word 2000 (OS WNT 4): MS Visual Basic: compile error in hidden module-WFMain. Have not been able to find completely satisfactory answer based upon other responses to similar error messages, just not this particular module: 1. Do not have...
  11. quicklearner

    method 'Range' of Object '_global' failed

    i am new to vb and i am writing a small code to get records from access database based on a selection criteria and then create an excel sheet using that data. the sequence is as follows: -Starting the VB application goes to main selection screen -Select a particular record and create excel...

Part and Inventory Search

Back
Top