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 derfloh 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: hisbadbanana
  • Order by date
  1. hisbadbanana

    applying formula to summary only

    i have a formula for a custom task field: IIf([Number2]=4,IIf([Finish]<now()-14,"Yes","No"),"No") is there a way to manipulate the above formula to also check whether it's a summary task? thanks -hisbad
  2. hisbadbanana

    Resource names in a custom field

    sorry for the ambiguity... version 2003 standard. I populated the resource sheet using the wizard that grabs the names from Outlook. So when I am in the Gantt cgart view I use the Resource Names column to add a resource to a task. I would also like to have "Text1" (in the task row) to pull...
  3. hisbadbanana

    Resource names in a custom field

    I am using the Resource field that is populated from the Resource sheet. However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well. It's not available in the Import Values option It's not available as the formula I can't...
  4. hisbadbanana

    Excel - check for formula entered, not number

    The only problem with IsItTheRightFormula = "Stop Cheating You Little Toads" is.. if they try to get it right, i mean they really really try, and they get it wrong, you're still caling them a cheat. -hisbad
  5. hisbadbanana

    Excel - check for formula entered, not number

    when you have the Define Name box open, at the bottom there is a 'Refers to' field. in that field you should type "=GET.CELL(48,INDIRECT("rc",FALSE))" exactly as ive written it. let me know how you get on.
  6. hisbadbanana

    Excel - check for formula entered, not number

    this gives you a clear visible indicator. any cell that is a formula as apposed to a number will be highlighted by whatever format you put in the conditional formatting. i'm unsure of whatelse you want.
  7. hisbadbanana

    Resource in a custom field

    In MS Project... I am using the Resource field that is populated from the Resource sheet. However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well. It's not available in the Import Values option It's not available as the...
  8. hisbadbanana

    Excel - check for formula entered, not number

    go to Intert/Name/Define in the Names in workbook box type "isAformula" in the Rferes to box type "=GET.CELL(48,INDIRECT("rc",FALSE))" then just set the condition formatting for the cells you want to check as Formula is "=isAformula
  9. hisbadbanana

    Project: Summary group name

    i figured it out - can't be done withut VBA (well I couldn't do it without vba!) Private Sub Project_Change(ByVal pj As Project) Dim ts As Tasks Set ts = ActiveProject.Tasks For Each t In ts If Not t Is Nothing Then If Not t.Summary Then t.Text11 = t.Name & " (" &...
  10. hisbadbanana

    Project: Summary group name

    In MS Project is there a way of identifying a task's Summary Name? For example, I want the Text1 field to be [Name.Summary] & [Name] any ideas?
  11. hisbadbanana

    See a cell as empty when it has been filled in and cleared

    Ken Your answer looks a lot neater than mine even though (I think) they give the same result. Do they have an underlying difference? IOW, When would you use one ond not the other? Thanks HisBad
  12. hisbadbanana

    See a cell as empty when it has been filled in and cleared

    =ISBLANK(Sheet1!A1)
  13. hisbadbanana

    Outlook - insert new row(vba)

    include: & chr(32) &
  14. hisbadbanana

    replace some ascii characters with blanks

    have a look at Ken's post in this thread. excel special characters
  15. hisbadbanana

    Special characters in Excel

    the code works when i use it. i suggest you take geoff's advice and repost in the vba forum, ask why you can't get that code to run. thanks hisbad
  16. hisbadbanana

    VB to Save file as Month

    ActiveWorkbook.SaveAs Filename:="C:\Auto Invoices\Invoices " & MonthName(Month(Date)) & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False
  17. hisbadbanana

    Special characters in Excel

    i retried with my own advice and the change macro failed to run. i had to do the following to make it work. close excel. reopen with just the workbook you're working on. do as i said before but this time copy and paste this code. Private Sub Worksheet_Change(ByVal Target As Range) For x...
  18. hisbadbanana

    Special characters in Excel

    right click on your worksheet tab and choose "View Code" type this code Private Sub Worksheet_Change(ByVal Target As Range) Cells.Replace What:="&", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False Cells.Replace What:="/", Replacement:="", LookAt:=xlPart...
  19. hisbadbanana

    Using excel to track billable hours

    Enter this formula where you want the answer: =SUMIF(B5:B12,"RM",C5:C12)
  20. hisbadbanana

    countdown &gt; countup

    i have a macro that (while performing its task) counts down from 100 to zero. how do i make count up so it looks like a percentage. here's the one line of code that i need to change. Application.StatusBar = (100 / (n - myRow) * (i - myRow))

Part and Inventory Search

Back
Top