Search:

Type: Posts; User: dandi; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    795

    Re: User Form Caption (Excel 2000)

    Thanks Hans that worked just perfect!
  2. Replies
    3
    Views
    795

    User Form Caption (Excel 2000)

    I am using Excel's Visual Basic Editor to create a User Form and would like to add a variable to a Label caption. Is this possible? Something like: Your entry does not match the worksheet value...
  3. Replies
    3
    Views
    332

    Re: Excel formula (Excel 2000)

    I originally thought that the problem may have been caused by a protection error but it turns out that the problem was that I was using the cell as the control source for one of my user forms.
    ...
  4. Replies
    3
    Views
    332

    Re: Excel formula (Excel 2000)

    Interesting - when I copy just the one sheet and remove any links to the original workbook the problem goes away. I am only referencing the one sheet with my formula.
  5. Replies
    3
    Views
    332

    Excel formula (Excel 2000)

    I have a worksheet that is behaving strangely. I am entering an if formula in cell I18 =if(C18="","",$L$11) this formula is used to fill the next 25 rows. The formula works when data is...
  6. Replies
    1
    Views
    281

    Convert to Text File (Excel2000)

    I have an Excel Workbook that I save as a .txt file on a weekly basis. This week when I saved the .txt file it converted some of my numbers to dates. The numbers it converted have a hyphen ...
  7. Replies
    4
    Views
    411

    Re: email attachment (Excel 2000)

    This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their...
  8. Replies
    4
    Views
    411

    email attachment (Excel 2000)

    Is it possible to create a hypelink in a worksheet that not only creates a new email but also automaticaly attaches the worksheet to the outgoing email?

    Thanks
  9. Replies
    3
    Views
    455

    Re: FrontPage 98 on XP (FrontPage 98)

    Thanks I will watch out for that possiblity.
  10. Replies
    3
    Views
    455

    FrontPage 98 on XP (FrontPage 98)

    Quick question - would I encounter many problems running FrontPage 98 on Office XP or Windows 2000?
    THANKS
  11. Copy&Paste to new workbook (English/Excel 2000)

    I have a macro installed on about 20 office P.C.s that copies information from a working file on their local drive to a "gathering" file on a network drive (using Access for this project is not an...
  12. Replies
    3
    Views
    365

    Footers on Landscape Page (Word2000)

    I am inserting data from an Excel worksheet into the middle of my Word document. The Excel data needs to print out landscape (I have created page breaks and changed the page orientation) but the...
  13. Replies
    4
    Views
    405

    Re: Conditional Formatting (Excel 2000)

    I gave it one more try and it worked this time (??). Thanks for persevering. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
  14. Replies
    4
    Views
    405

    Re: Conditional Formatting (Excel 2000)

    I have tried several version of an IS formula including the one you suggested. They work if I place them in another cell then reference the cell in my Formula Is but not if I place them directly in...
  15. Replies
    4
    Views
    405

    Conditional Formatting (Excel 2000)

    Is it possible to conditionally format a cell based on if the formula returns an error message? For example can you set the font color to be red if the formula returns #N/A
  16. Replies
    3
    Views
    394

    Re: Vlookup & Dget (Excel97)

    THANKS that works like a charm! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
  17. Replies
    3
    Views
    394

    Vlookup & Dget (Excel97)

    I am trying to use vlookup to gather the info needed for part of my Dget formula however; when I insert the value returned into my Dget formula the formula does not recognize the value (I end up with...
Results 1 to 17 of 17